Using pg_dump and pg_dumpall I ran into the following problems and had addressed it earlier to this list with no response.
Using PostgreSQL 7.2.x 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 to restore the databases and it fails. The problem is that the user does not have createdb privilege and therefore the system cannot create a database with that particular user as the owner. Is it possible to address this before the 7.3 release or is this concern no longer a problem in the 7.3 branch? ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
