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