
	Where results make sense

Topic: Postgres

Related Topics

PostgreSQL

SQL

Impedance mismatch

Informix

Michael Stonebraker

View

Venona

Donovan

Doc Ames

Mike Grell

Trigger

Angora

Percy Shelley

Samos

BBC Radio 4

	PGINTRO(UNIX) manual page
		Note that the Postgres super-user is not the same as the Unix super-user, root, and should have a non-zero userid for security reasons.
		The Postgres backend (the actual executable program called "postgres") may be executed directly from the user shell by the Postgres super-user (with the database name as an argument).
		Postgres provides mechanisms to allow users to limit the access to their data that is provided to other users.
	www.ucolick.org /~de/PG/Man/pgintro.1.html (1323 words)

	postgres
		When postgres is started by a postmaster(1) then it inherits all options set by the latter.
		If postgres is running under the postmaster, this option is ignored, and the stderr inherited from the postmaster is used.
		It is also unwise to send SIGKILL to a postgres process --- the postmaster will interpret this as a crash in postgres, and will force all the sibling postgres processes to quit as part of its standard crash-recovery procedure.
	linuxcommand.org /man_pages/postgres1.html (1290 words)

	Pike Reference manual - Postgres.postgres
		Postgres is quite slow, and so you might want to consider this particular aspect.
		The behavior of the Postgres C API also depends on certain environment variables defined in the environment of the pike interpreter.
		Sets the default port to connect to, otherwise it will use compile-time defaults (that is: the time you compiled the postgres library, not the Pike driver).
	pike.oav.net /7.4/ex/Postgres/postgres.html (365 words)

	[No title]
		Postgres by default uses fsync() after each write() to write the data to disk, but I've commented these out for the current version of Postgres (ipcdelta was enough kernel patching)...
		The Postgres DBMS is extended relational or object oriented, depending on the buzzword du jour.
		The Postgres V4.0.1 was only a bug fix release relative to 4.0, so don't believe, you will have a robust database system with this version of Postgres.
	www.ibiblio.org /pub/historic-linux/ftp-archives/tsx-11.mit.edu/Oct-07-1996/ports/Postgres/postgres.README (2157 words)

	Accessing Postgres through Whitebeam
		Postgres has been an integral part of a whitebeam installation since its open source debut back in June 2001.
		Postgres has however been hidden behind 'templates', which abstract away the complexities of dealing with complex database structures.
		Consistent with Whitebeams aim to provide an ISP friendly application development environment, Whitebeams Postgres interface can be customised through directives in the Apache configuration file (httpd.conf) allowing the ISP to specify which users can access which databases without having to configure the database for each new user.
	www.whitebeam.org /library/guide/TechNotes/postgres.rhtm (1145 words)

	A Short History of Postgres (Site not responding. Last check: 2007-10-08)
		Implementation of the Postgres DBMS began in 1986.
		Postgres has also been used as an educational tool at several universities.
		Postgres95 is a derivative of the last official release of Postgres (version 4.2).
	www.ninthwonder.com /info/postgres/user/intro56.htm (686 words)

	Postgres Architecture and Administration
		The number of server process that can be invoked on any database system is 32 by default, but this can be as high as 1024 if the system supports it.
		Postgres will need only one operating system account to make an installation, although this account can be any name, it is recommended that this user be named
		Within every database system there is a file called pg_hba.conf, this text file controls access to every piece of the database system, it is possible to specify a great deal of access controls like : IP Address origin, kerbros authentication, database..etc.(Note: It mentions database, recall that a databasesystem is composed of various databases).
	www.osmosislatina.com /postgres/part2.htm (697 words)

	The POSTGRES95 User Manual - ADVANCED POSTGRES SQL FEATURES (Site not responding. Last check: 2007-10-08)
		POSTGRES does not have this restriction; attributes can themselves contain sub-values that can be accessed from the query language.
		POSTGRES allows attributes of an instance to be defined as fixed-length or variable-length multi-dimensional arrays.
		By default, POSTGRES uses the "one-based" numbering convention for arrays -- that is, an array of n elements starts with array[1] and ends with array[n].
	www.math.eku.edu /tools/pg_manual/advanced.html (820 words)

	+++ATH0: postgres ... turtle or hare?
		Using my own laptop as a test case, I'm running 7.4 postgres, a copy of Apache v1.whatever, and PHP 4.3.4 and receiving connect times of 19.88902* ms or larger (degree of variance is about 3%), while running MySQL the connection time is significantly lower.
		Having read through the postgres mailing lists, the biggest suggestion is that I shouldn't be killing my Apache processes too quickly (not a valid reason in this case) to benefit from pconnects (duh).
		I'm not a postgres user (though I have used it), but I am a big Oracle user, and the process model seems similar.
	www.deadmime.org /~dank/blog/2004/03/22/postgres_turtle_or_hare.html (1255 words)

	PostgreSql UPS Installation (Site not responding. Last check: 2007-10-08)
		Initially there is no data directory in the postgres product instance and the users will have a choice to configure PGDATA directory to create their own database cluster.
		If postgres installer is a root user then it has to be postgres groupname on this machine: ups tailor will change groupname root to postgres to access postgres databases by postgres server.
		If postgres group name does not exist on user's machine, there will be message with request to add an entry for postgres group to the user's system /etc/group file or NIS group map.
	www-css.fnal.gov /dsg/external/freeware/pgsql_ups.html (1601 words)

	Embedding R in Postgres (Site not responding. Last check: 2007-10-08)
		Postgres relational database and use R functions as if they were built-in SQL functions.
		While this is likely to change in the coming months, please be aware of the potential dangers in using this package in publically accessible Postgres servers.
		You will need to have the source of the Postgres distribution since this package needs access to the public but internal aspects of the database engine, not the client libraries.
	www.omegahat.org /RSPostgres (266 words)

	[No title]
		Grant the "postgres" user the "Log on as a service" user right: # cmd /c secpol.msc # [3] [4] [5] [12] 4.
		Connect to PostgreSQL: # psql -U postgres template1 # [8] [9] The following are the notes to the above: [1] The "#" prompt indicates running as a user which is a member of the Local Administrators group.
		Log in as "postgres" or use ssh to emulate Unix's "su" command.
	www.tishler.net /jason/software/postgresql/postgresql-7.4.1.README (874 words)

	Postgres real time mirroring
		There is also a tool called, "dbmirror" in the postgres source tree, under /contrib, but I have no experience with this and I think it is not real time mirroring.
		Postgres replication is fully possible, but will take some work to get it going, it won't be seamless like a commerical product like SQLServer or Oracle.
		One thing that you might find interesting, is that the.INFO registry runs on a Postgres replicated database, and the.ORG registry is moving to a Postgres replicated database.
	forums.devshed.com /t45981/s.html (269 words)

	PostgreSQL versus MySQL. (Site not responding. Last check: 2007-10-08)
		Postgres is relatevly slow due to the nature of the table constraints.
		Postgres and jbdc for Postgres are much worse in this aspect.
		Postgres has some important issues to be prepared to start postmaster with server-client options: 1.
	www-css.fnal.gov /dsg/external/freeware/Repl_mysql_vs_psql.html (700 words)

	Postgres? (Site not responding. Last check: 2007-10-08)
		Lots of people have been asking for other database support; Postgres and Oracle, specifically (not too many requests for MS SQL Server, for some cough odd reason...) So.
		It doesn't seem to take advantage of indices; Mysql is still far faster than Postgres with huge amounts of data and the right fields indexed.
		Postgres only supports inserting multiple rows with a single command if it's the results from a SELECT query, i.e., "INSERT INTO stats VALUES SELECT * FROM other_stats".
	nisca.sourceforge.net /postgres.html (334 words)

	Linux: postgres (Site not responding. Last check: 2007-10-08)
		GENERAL PURPOSE The options -A, -B, -c, -d, -D, -F, and --name have the same meanings as the postmaster(1) except that -d 0 prevents the debugging level of REINDEX command for system tables/indexes requires this option to be used.
		The postmaster uses SIGTERM to tell a postgres process to quit normally and SIGQUIT to ter- minate without the normal cleanup.
		Start a stand-alone backend with a command like postgres -D $PGDATA other-options my_database Provide the correct path to the database area with -D, or make sure that the environment variable PGDATA is set.
	www.linuxforum.com /man/postgres.1.php (1042 words)

	[Dbdpg-general] unicode : perl<->postgres
		Now I encountered two problems and it seems to me that I never managed to let postgres see the delivered text as real unicode.
		A) If I let postgres sort fields the sorting-order is very confusing B) If I run the lower-function on the fields it returns irritating values.
		I am sure that postgres gets the multibytestring from perl and doesnt read it as unicode-string, but just as simple single-byte-string and when ordering or lowering it just processes the string byte for byte.
	gborg.postgresql.org /pipermail/dbdpg-general/2003-September/000434.html (578 words)

	Postgres Postmaster Carks It... (Site not responding. Last check: 2007-10-08)
		Daryl > >...it is possible that the transaction is way too large to unroll I > > guess (I hadn't thought of that -- does Postgres keep the transaction in > > memory until you commit it which would give this type of behaviour)...
		Note that it does pay to do a batch of > inserts within a transaction, because this speeds up the inserts > no end (at least, this used to be the case - I haven't tried it on > recent Postgres's's to see if that's changed).
		This was clearly the problem because the moment I removed the BEGIN and COMMIT, the import went perfectly although I will probably have to use Perl and some time functions to get the timestamp to get it in ther.
	www.linuxsa.org.au /pipermail/linuxsa/2002-July/042709.html (211 words)

	University POSTGRES 4.2 (Site not responding. Last check: 2007-10-08)
		You may also wish to consult the monthly digests of the POSTGRES mailing list archives.
		Patches for POSTGRES 4.2, generated by various users.
		POSTGRES does not come with a GUI query tool, but a very nice one called pgbrowse (based on Tcl/TK) is available from UCSB/CRSEO.
	db.cs.berkeley.edu /postgres.html (157 words)

	DBBalancer: Load balancing database connection pool for Postgres.
		Currently the only server supported is Postgres, but the architecture is open to embrace more servers in a future.
		I know that both Postgres and MySQL have been working on replication and right now (January 2001) there are stable versions with replication capabilities.
		I don't know if this is gonna be of real utility to anyone, but here it is. By now I'd be happy if people gave me their impressions about the program and, specially, good suggestions and ideas on how to improve it.
	dbbalancer.sourceforge.net (1276 words)

	The dot in ... --- ...
		The service in question was a very small Postgres database, which on Solaris 9 had been started from rc3.d.
		Moving the rc script over to 10 worked but I wanted a fuller smf experience so decided to create a manifest and import that into smf on the zone running the database.
		Now killing postgres using kill or pkill results in the database being restarted.
	blog.sun.com /roller/page/chrisg?anchor=my_first_smf_service (351 words)

	Contribs.org-Forums - General discussion :: Postgres 8.0.1 install problem (Site not responding. Last check: 2007-10-08)
		A Google check of this file shows it is related to Openssl but could not figure out where it is. A check of the files in Openssl RPM package does not show it.
		You don't say where you got your Postgres 8.0.1 RPM from, but I'm sure it's not compiled to work with RedHat 7.3.
		Grab the postgres RPMs from RH 7.3 (or FedoraLegacy 7.3) and you won't have this problem.
	contribs.org /modules/pbboard/viewtopic.php?t=26726 (355 words)

	A Short History of Postgres (Site not responding. Last check: 2007-10-08)
		With over a decade of development behind it, PostgreSQL is the most advanced open-source database available anywhere, offering multi-version concurrency control, supporting almost all SQL constructs (including subselects, transactions, and user-defined types and functions), and having a wide range of language bindings available (including C, C++, Java, perl, tcl, and python).
		We chose a new name, PostgreSQL, to reflect the relationship between the original Postgres and the more recent versions with SQL capability.
		The emphasis during development of Postgres95 was on identifying and understanding existing problems in the backend code.
	www.msoe.edu /webdev/docs/postgres/user/intro56.htm (740 words)

	postgres
		Some (safe) options can also be set from the connecting client in an application-dependent way.
		is set, then libpq-based clients will pass that string to the server, which will interpret it as postgres command-line options.
		To tell postgres to reread the config file, use a
	www.gustavus.edu /+karl/courses/mcs270-s03/pgsql/app-postgres.html (833 words)

	Linux Pipeline \| Review: Pervasive Postgres 8 (Site not responding. Last check: 2007-10-08)
		A key new feature in Postgres 8 is the ability to run the database as a Windows service on a variety of Windows platforms, including Windows 2000 Professional and Server, 2003 Standard and Enterprise, and XP Professional.
		Server-side language support is key to making Postgres an enterprise-class contender: MySQL doesn't have this kind of functionality, but other enterprise-class databases, such as Oracle and SQL Server, do.
		After running the computer for about 30 seconds, I bravely simulated a catastrophic failure by pulling the plug on the Postgres server while the system was writing data.
	www.linuxpipeline.com /showArticle.jhtml?articleID=160503279 (1268 words)

	CISE Computer Help
		The page can also be used to set a new password for an existing Postgres account if you have forgotten your password.
		To use Postgres in perl, use the DBD::Postgres module.
		For anyone interested in using the Ruby language, there's also support for Postgres in Ruby on CISE systems, using a DBI module modelled after the perl DBI scheme.
	www.cise.ufl.edu /help/database/postgres.shtml (322 words)

	postgres backup
		My postgres dump will go to birkinbackup, and then in a separate step be sent from my birkinbackup user to Jean's birkinbackup user.
		Because of my sense that postgres users are distinct from linux users, and knowing that I can access my postgres data via a JDBC connection specifying a postgres username that is not a linux username, I was confused about why this step is necessary, even though it does work.
		After discussions with Jean, my sense is that if no user is specified in the request/command, postgres will default to using a postgres user that has a name that matches the linux user-account.
	bob.marlboro.edu /~bjdiana/capstone/postgres_backup.shtml (3133 words)

	POSTRES (Site not responding. Last check: 2007-10-08)
		This document is taken from the reference manual for the POSTGRES database management system under development at the University of California at Berkeley.
		The POSTGRES project, led by Professor Michael Stonebraker, is sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc. POSTGRES is distributed in source code format and is the property of the Regents of the University of California.
		POSTGRES has been constructed by a team of undergraduate, graduate, and staff programmers.
	info.fuw.edu.pl /market/postgres.html (303 words)

Try your search on: Qwika (all wikis)