From: | "Kieran McCusker" <kieran(dot)mccusker(at)kwest(dot)info> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4431: cannot pg_restore from pg_dump --format=c |
Date: | 2008-09-22 10:49:03 |
Message-ID: | 200809221049.m8MAn3SD002200@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
If I do the same thing using pg_dump --format=p and loading it using psql
it
works fine. The database was originally created under fc7 (sorry can't
remember the postgresql version) Its a bit worrying as it means none of the
previous nightly
backups are usable.
I can provide the dump if needed (its 230Mb compressed 1.8Gib uncompressed)
Many thanks
Kieran
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-09-22 12:03:22 | Re: BUG #4431: cannot pg_restore from pg_dump --format=c |
Previous Message | Tom Lane | 2008-09-22 03:39:17 | Re: Error in starting PostgreSQL Server 7.4 after crash |