On 02/16/2012 11:31 AM, Edward W. Rouse wrote:
> To answer the second question first, yes; both as the same user.
>
> pg_dump -v -f $bkfile -F c -U $USER $DATABASE
So how are you determining that only the public schema is being dumped?
One thing to check is the search_path setting in postgresql.conf. This
can create the illusion that only one schema is available in a database.
One way to check is to use the fully qualified name for a table you know
to be in the reports schema. Ex:
select * from reports.some_table;
>
>
>
>
--
Adrian Klaver
adrian.klaver@gmail.com