pg_restore problem

Поиск

Список

Период

Сортировка

От	lists
Тема	pg_restore problem
Дата	28 марта 2003 г. 07:34:32
Msg-id	003201c2f526$8e88fd60$8efaabc8@insyde обсуждение исходный текст
Ответы	Re: pg_restore problem
Список	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.

В списке pgsql-admin по дате отправления: