summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/dropdb.sgml
Commit message (Collapse)AuthorAgeFilesLines
* Add reference to libpq environment variables for client applications.Bruce Momjian2005-05-291-1/+2
|
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-291-1/+1
|
* Mop-up for error-message updates in documentation.Tom Lane2003-09-121-12/+18
|
* More cleanup of Diagnostics sections.Tom Lane2003-09-121-34/+16
|
* Add/edit index entries.Peter Eisentraut2003-08-311-1/+5
|
* Add documentation to 'createuser' that ALTER USER must be used to add orBruce Momjian2003-05-261-5/+5
| | | | | | modify passwords, per user confusion report. Also clean up wording that command line utils need database access.
* Another big editing pass for consistent content and presentation.Peter Eisentraut2003-03-241-9/+7
|
* Reimplement create and drop scripts in C, to reduce repetitivePeter Eisentraut2003-03-181-12/+9
| | | | | connections, increase robustness, add NLS, and prepare for Windows port. (vacuumdb and clusterdb will follow later.)
* Assorted reference page updatesPeter Eisentraut2002-10-111-40/+45
|
* Add more appropriate markup.Peter Eisentraut2002-09-211-8/+15
|
* Make sure all clients have the same understanding of default user namePeter Eisentraut2002-08-101-5/+1
| | | | | and database. In particular, make script wrappers understand the PGDATABASE environment variable.
* Structure reference pages consistently. Document that structure.Peter Eisentraut2002-07-281-37/+64
| | | | Add information about environment variables.
* Augment the date/time examples in the User's Guide to reflect the newerThomas G. Lockhart2002-04-211-5/+1
| | | | | | | | | capabilities of specifying time zones as intervals per SQL9x. Put refentrytitle contents on the same line as the tag. Otherwise, leading whitespace is propagated into the product, which (at least) messes up the ToC layout. Remove (some) docinfo tags containing dates. Best to omit if the dates are not accurate; maybe use CVS dates instead or leave them out.
* Spell-check and markup policePeter Eisentraut2002-01-201-3/+3
|
* Use PostgreSQL consistantly throughout docs. Before, usage was split evenlyThomas G. Lockhart2001-12-081-2/+2
| | | | between Postgres and PostgreSQL.
* proof-readingPeter Eisentraut2001-11-281-10/+10
|
* Put some kind of grammatical uniformity in the <refpurpose> lines.Peter Eisentraut2001-09-031-2/+2
|
* Patch NAME section of reference pages.Bruce Momjian2001-08-131-2/+2
|
* Refine some things to create better looking man pages.Peter Eisentraut2000-12-251-4/+4
|
* Make socket option specify just the directory, not the full path.Bruce Momjian2000-11-221-2/+2
|
* Add mention of hostname leading slash handling to all manual pages that use -h.Bruce Momjian2000-11-131-2/+3
|
* Remove -k unix socketpath option from client side, allow hostname withBruce Momjian2000-11-131-13/+1
| | | | leading slash to behave as a unix socket path.
* UUNET is looking into offering PostgreSQL as a part of a managed webBruce Momjian2000-11-131-1/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | hosting product, on both shared and dedicated machines. We currently offer Oracle and MySQL, and it would be a nice middle-ground. However, as shipped, PostgreSQL lacks the following features we need that MySQL has: 1. The ability to listen only on a particular IP address. Each hosting customer has their own IP address, on which all of their servers (http, ftp, real media, etc.) run. 2. The ability to place the Unix-domain socket in a mode 700 directory. This allows us to automatically create an empty database, with an empty DBA password, for new or upgrading customers without having to interactively set a DBA password and communicate it to (or from) the customer. This in turn cuts down our install and upgrade times. 3. The ability to connect to the Unix-domain socket from within a change-rooted environment. We run CGI programs chrooted to the user's home directory, which is another reason why we need to be able to specify where the Unix-domain socket is, instead of /tmp. 4. The ability to, if run as root, open a pid file in /var/run as root, and then setuid to the desired user. (mysqld -u can almost do this; I had to patch it, too). The patch below fixes problem 1-3. I plan to address #4, also, but haven't done so yet. These diffs are big enough that they should give the PG development team something to think about in the meantime :-) Also, I'm about to leave for 2 weeks' vacation, so I thought I'd get out what I have, which works (for the problems it tackles), now. With these changes, we can set up and run PostgreSQL with scripts the same way we can with apache or proftpd or mysql. In summary, this patch makes the following enhancements: 1. Adds an environment variable PGUNIXSOCKET, analogous to MYSQL_UNIX_PORT, and command line options -k --unix-socket to the relevant programs. 2. Adds a -h option to postmaster to set the hostname or IP address to listen on instead of the default INADDR_ANY. 3. Extends some library interfaces to support the above. 4. Fixes a few memory leaks in PQconnectdb(). The default behavior is unchanged from stock 7.0.2; if you don't use any of these new features, they don't change the operation. David J. MacKenzie
* Markup enhancements, some factual corrections.Peter Eisentraut2000-11-111-51/+43
|
* Start updating for the v7.0 release.Thomas G. Lockhart2000-03-271-5/+5
| | | | | Use "generic functions" for math and other routines. Use SQL92 "type 'literal'" syntax rather than Postgres "'literal'::type".
* Okay, that should put us back in sync. These two patches (src & doc) areBruce Momjian1999-12-071-2/+2
| | | | | | | | | | | | | | | against the sources from one hour ago and contain all the portable and up to date stuff. A few other CVS "householding" things you might want to take care of: * Remove the src/bin/cleardbdir directory * Remove the file src/bin/psql/sql_help.h from the repository, as it is a derived file and is build by the release_prep. Peter Eisentraut
* New scripts for create/drop user/db from Peter EisentrautBruce Momjian1999-12-041-0/+232