pg_dump and pg_restore make data dir doubled size?

From: Yan Chunlu <springrider(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump and pg_restore make data dir doubled size?
Date: 2011-12-18 14:18:28
Message-ID: CAOA66tEv_hmBoOD2aZ-rMH7HAHDtOSKOVX5vQUYjSdnAHhRPhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2011-12-18 18:13:43 Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
Previous Message Tom Lane 2011-12-18 04:25:47 Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."