From: lists <lists@insyde.com.br>
To: pgsql-admin@postgresql.org
Subject: pg_restore problem
Date: Fri, 28 Mar 2003 09:35:44 -0300
Message-ID: <003201c2f526$8e88fd60$8efaabc8@insyde> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lists@insyde.com.br
Subject: Re: pg_restore problem
In-Reply-To: <003201c2f526$8e88fd60$8efaabc8@insyde>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox