pg_dump and pg_restore make data dir doubled size?

Поиск
Список
Период
Сортировка
От Yan Chunlu
Тема pg_dump and pg_restore make data dir doubled size?
Дата
Msg-id CAOA66tEv_hmBoOD2aZ-rMH7HAHDtOSKOVX5vQUYjSdnAHhRPhg@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump and pg_restore make data dir doubled size?
Список pgsql-general
Дерево обсуждения 
I just tried several times to make sure I didn't do anything wrong.

I use
pg_dump -U postgres  -E UTF8  -F c -b -v -a  dbcontent -f  data.backup
then
pg_restore -a -d dbcontent data.backup

to restore a db, and the data dir's size on the source machine is
56GB,  after I restored data on the target machine, it 130GB,  I did
vacuum full but nothing changed.

is there anything wrong with the db?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
Следующее
От: Rick Pufky
Дата:
Сообщение: recovery_target_timeline and multiple slave behavior when master fails