Re: [HACKERS] pg_dump, pg_dumpall and createdb privilege

2002-08-19 Thread Neil Conway
Thomas Swan [EMAIL PROTECTED] writes: 1. create a user with createdb privilege. 2. create a database as that user (allowing that user full reign over that particular db) 3. drop the createdb from the user. 4. pg_dumpall the databases to a single file 5. either use pg_restore or psql infile

Re: [HACKERS] pg_dump, pg_dumpall and createdb privilege

2002-08-19 Thread Thomas Swan
Neil Conway wrote: Thomas Swan [EMAIL PROTECTED] writes: 1. create a user with createdb privilege. 2. create a database as that user (allowing that user full reign over that particular db) 3. drop the createdb from the user. 4. pg_dumpall the databases to a single file 5. either