pg_dump and pg_restore make data dir doubled size?
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?
never mind. just found I changed the wal_keep_segments to 5000, it's
the size of pg_xlog dir who used a lot of space.
Show quoted text
On Sun, Dec 18, 2011 at 10:18 PM, Yan Chunlu <springrider@gmail.com> wrote:
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.backupto 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?