Not sure how else to describe this: basically if you type in pg_dump
<databasename> then all databases on the system that have table grants
to public are also in the backup .sql file with connect commands to the
other database users.
Do you mean pg_dumpall? Because pg_dump will ONLY dump the database you
specify, nothing else.
Joshua D. Drake
Restoring, therefor, is not possible by that user because the restore
procedure wants to restore other databases that are not owned by the
owner of the database that was supposed to be backed up.
TTYL,
Blair.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
