Home > mailing lists

pg_restore problem - Mailing list pgsql-admin

From	lists
Subject	pg_restore problem
Date	March 28, 2003 07:34:32
Msg-id	003201c2f526$8e88fd60$8efaabc8@insyde Whole thread Raw
Responses	Re: pg_restore problem
List	pgsql-admin

Hi,

I've a dump I made with the command:

pg_dump -a -b -Fc -f DB.dump -o -v DB

then I try to restore with:

pg_restore -a -d DB2 -Fc -o -v DB.dump

This database is about 1.5Gb big.

The dump takes abou 1 hour, but the restore takes forever!

Last time I ran it, it takes more than 10 hours, when I gave up

and stopped the process.

Tried with both Ft and Fc.

Another doubt: Why a dump of this DB with Ft has about the

same size of the original DB(1.5GB) and with Fc it has about 50MB?

My system is:

P3 1Ghz, 1GB ram, Win2k, Postgres 7.2.2

Free space ~5GB.

TIA,

Ricardo.

From: "Tatiana Motova"
Date: 28 March 2003, 06:55:41
Subject: Re: pg_dump problem

From: Peter Eisentraut
Date: 28 March 2003, 08:54:36
Subject: Re: [ Possible problem with Postgres ]