Re: pg_dump and grants to PUBLIC

> 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/