BUG #4425: cannot pg_restore from pg_dump --format=c

From: "Kieran McCusker" <kieran(dot)mccusker(at)kwest(dot)info>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4425: cannot pg_restore from pg_dump --format=c
Date: 2008-09-18 17:37:26
Message-ID: 200809181737.m8IHbQVA031466@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: 4425
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 version) Its a bit worrying as it means the previous nightly
backups are not usable.

Browse pgsql-bugs by date

  From Date Subject
Next Message Andreas Peer 2008-09-19 08:16:15 Re: BUG #4421: convert_to() should be immutable
Previous Message Michael Ojukwu 2008-09-18 15:56:33 BUG #4424: Change PostGreSQL Password Affects