summaryrefslogtreecommitdiff
path: root/src/bin/scripts/createuser
Commit message (Collapse)AuthorAgeFilesLines
* Reimplement create and drop scripts in C, to reduce repetitivePeter Eisentraut2003-03-181-265/+0
| | | | | connections, increase robustness, add NLS, and prepare for Windows port. (vacuumdb and clusterdb will follow later.)
* At present it is impossible to kill createuser except with kill -9Bruce Momjian2003-02-191-2/+2
| | | | Oliver Elphick
* This patch fixes an error in the usage message for 'clusterdb', andBruce Momjian2003-02-131-3/+3
| | | | | | | makes a few editorial changes to the documentation. Neil Conway
* Improve formatting of --help output.Peter Eisentraut2002-10-181-17/+20
|
* Improve appearance of SET command.Bruce Momjian2002-10-161-2/+2
|
* Fix script to handle autocommit = 'off' by prepending autocommit 'on' toBruce Momjian2002-10-161-2/+2
| | | | | | the start of the psql commandline. This is better than adding BEGIN/END because it handles multiple queries well, and allows the return code for psql to return the proper value.
* Update copyright to 2002.Bruce Momjian2002-06-201-2/+2
|
* Allow prompting of create/drop user to handle spaces.Bruce Momjian2002-04-121-2/+12
|
* Allow dropdb and others to use identifiers with spaces; IFS cleanup forBruce Momjian2002-04-121-5/+5
| | | | pg_dumpall.
* Fix param handling of create* admin scripts as described months ago.Bruce Momjian2002-02-181-1/+6
| | | | Properly handles default values.
* These are further fixes for double quotes missing in the various shellBruce Momjian2001-09-301-6/+6
| | | | | | scripts. Justin Clift
* sbasename $0 is now basename "$0"Bruce Momjian2001-09-221-2/+2
|
* Add single-letter encryption options for createuser. Update createuser --help.Bruce Momjian2001-08-261-3/+5
|
* Put createuser ENCRYPTED/UNENCRYPTED in the proper place in the query.Bruce Momjian2001-08-261-4/+4
|
* Add ENCRYPTED/UNENCRYPTED control in createuser script.Bruce Momjian2001-08-251-1/+10
|
* Add copyright mentions, per Tom Lane.Bruce Momjian2001-02-181-2/+3
|
* Put quotes around environment variables.Bruce Momjian2001-01-211-10/+10
|
* Advertise --help (rather than '-?') as help option (problems with csh).Peter Eisentraut2000-11-251-2/+2
| | | | Accept --help even if no general long options support exists.
* Remove -k unix socketpath option from client side, allow hostname withBruce Momjian2000-11-131-11/+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/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* Make sure shell scripts send error messages to stderr.Peter Eisentraut2000-11-111-6/+9
| | | | | Improve help output. Teach droplang to remove 'pltclu'.
* Back out pg_shadow changes to allow create table and locking permissions.Bruce Momjian2000-06-121-45/+1
|
* I have large database and with this DB work more users and I very needBruce Momjian2000-06-091-1/+45
| | | | | | | | | | | | | | | | | | | | | | | | more restriction for fretful users. The current PG allow define only NO-CREATE-DB and NO-CREATE-USER restriction, but for some users I need NO-CREATE-TABLE and NO-LOCK-TABLE. This patch add to current code NOCREATETABLE and NOLOCKTABLE feature: CREATE USER username [ WITH [ SYSID uid ] [ PASSWORD 'password' ] ] [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ] -> [ CREATETABLE | NOCREATETABLE ] [ LOCKTABLE | NOLOCKTABLE ] ...etc. If CREATETABLE or LOCKTABLE is not specific in CREATE USER command, as default is set CREATETABLE or LOCKTABLE (true). A user with NOCREATETABLE restriction can't call CREATE TABLE or SELECT INTO commands, only create temp table is allow for him. Karel
* More changes of >& to 2>&1Bruce Momjian2000-03-251-6/+6
|
* another round of user interface cleanupsPeter Eisentraut2000-01-191-12/+16
| | | | | removed pg_id fixed a few bugs in the scripts
* Removed MBFLAGS from makefiles since it's now done in include/config.h.Peter Eisentraut2000-01-191-2/+20
|
* * User management commands no longer user pg_exec_query_dest -> more robustPeter Eisentraut2000-01-141-2/+2
| | | | | | | | | | | | * Let unprivileged users change their own passwords. * The password is now an Sconst in the parser, which better reflects its text datatype and also forces users to quote them. * If your password is NULL you won't be written to the password file, meaning you can't connect until you have a password set up (if you use password authentication). * When you drop a user that owns a database you get an error. The database is not gone.
* Fixed a few "fixes" and bugs. Adjusted messages and options to GNU suggestions.Peter Eisentraut2000-01-121-20/+19
|
* Hi,Bruce Momjian1999-12-161-9/+20
| | | | | | | | | | | | | | | | | I sending promised patch with: * getopt_long() - for pg_dump (portable) * and "Usage: " changes in scripts in src/bin/ - this changes are cosmetic only, not change any feature ...etc. All PostgreSQL routines (scripts) support now long options and help's output is alike for all scripts and all support -? or --help. Karel Karel Zak <zakkr@zf.jcu.cz> http://home.zf.jcu.cz/~zakkr/
* Okay, that should put us back in sync. These two patches (src & doc) areBruce Momjian1999-12-071-13/+58
| | | | | | | | | | | | | | | 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
* Fix echo -n and read -r in scripts.Bruce Momjian1999-12-051-10/+20
|
* New scripts for create/drop user/db from Peter EisentrautBruce Momjian1999-12-041-0/+145
View Lorry Controller Status