| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | "Edward W(dot) Rouse" <erouse(at)comsquared(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: pg_dump - 8.3 - schemas |
| Date: | 2012-02-16 20:22:06 |
| Message-ID: | 4F3D656E.50900@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 02/16/2012 12:17 PM, Edward W. Rouse wrote:
> Well, when I do a restore using the created file, reports isn't there. i.e.
> the select from reports.table gives an error and, from psql, \l doesn't list
> it and \dn doesn't show it. But that all does work on the original database.
What is the error reported?
What do the Postgres logs show when you restore the data?
Do a pg_restore -l against the dump file. This will list the contents of
the dump. See if the schema and contents are there.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vpapavas | 2012-02-17 01:01:43 | Window function frame clause |
| Previous Message | Edward W. Rouse | 2012-02-16 20:17:48 | Re: pg_dump - 8.3 - schemas |