Skip site navigation (1) Skip section navigation (2)

Re: pg_dump - 8.3 - schemas

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-sql by date

Next:From: vpapavasDate: 2012-02-17 01:01:43
Subject: Window function frame clause
Previous:From: Edward W. RouseDate: 2012-02-16 20:17:48
Subject: Re: pg_dump - 8.3 - schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group