Postgres Pro
Downloads
Home   >   mailing lists

pg_dump and pg_restore make data dir doubled size? - Mailing list pgsql-general

From Yan Chunlu
Subject pg_dump and pg_restore make data dir doubled size?
Date
Msg-id CAOA66tEv_hmBoOD2aZ-rMH7HAHDtOSKOVX5vQUYjSdnAHhRPhg@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump and pg_restore make data dir doubled size?  (Yan Chunlu <springrider@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
Next
From: Rick Pufky
Date:
Subject: recovery_target_timeline and multiple slave behavior when master fails