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

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 (view raw or flat)
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

pgsql-bugs by date

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

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