Re: BUG #4431: cannot pg_restore from pg_dump --format=c

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kieran McCusker" <kieran(dot)mccusker(at)kwest(dot)info>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4431: cannot pg_restore from pg_dump --format=c
Date: 2008-09-22 12:03:22
Message-ID: 11489.1222085002@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Kieran McCusker" <kieran(dot)mccusker(at)kwest(dot)info> writes:
> The following bug has been logged online:

> Bug reference: 4431
> Logged by: Kieran McCusker
> Email address: kieran(dot)mccusker(at)kwest(dot)info
> PostgreSQL version: 8.3.3
> Operating system: Linux (fc9)
> Description: cannot pg_restore from pg_dump --format=c
> Details:

> Hi

> I'm trying to copy a database between two servers (both fc9).

> If I do the following:-

> pg_dump --format=c --username=portal --file=test.dump Portal

> Create the database using:-

> createdb -E utf8 --owner=portal --template postgres Portal

> then:

> pg_restore --dbname=Portal test.dump

> The database schema is partially restored and no data added.

This report is completely laxking in any detail that might allow anyone
to help you. What do you mean by "partially restored" --- what gets
restored and what doesn't? What error messages do you get? (Look in
the postmaster log as well as what comes out of pg_restore.)

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message security improvement proposal: pg_hba.conf and CIDR mask 2008-09-23 09:44:24 BUG #4433: entries like "host all all 10.0.50.31/0 ..." should not be allowed or trigger a warning
Previous Message Kieran McCusker 2008-09-22 10:49:03 BUG #4431: cannot pg_restore from pg_dump --format=c