Thread: pg_Restore

pg_Restore

From
bhanu udaya
Date:
<div dir="ltr">Hello,<br /> <br />Greetings !<br />I am new to postgres and recently got migrated from oracle.<br />I
amtrying to restore 9.5G database (1GB dumpfile) which has 500 schemas with 1 lakh rows in each schema. Could take the
datadump using pg_dump and it takes around 40 minutes. I tried to use pg_restore to restore this dump, but it takes
hoursto restore the dump. I have used the configurations parameters as below:<br /> <br />shared_buffers = 1024MB   <br
/>work_mem= 512MB<br />maintenance_work_mem = 512MB<br />wal_buffers = 100MB<br /> <br />I have used command to restore
asbelow:<br />pg_Restore -d newdb -j2 e:\file.dmp<br /> <br />My machine configurations are as below:<br />Windows Core
I5with 4GB Ram.<br /> <br />Thanks for your help.<br /> <br />Thanks and Regards<br />Radha Krishna<br /></div> 

Re: pg_Restore

From
Guillaume Lelarge
Date:
On Mon, 2013-01-21 at 00:03 +0530, bhanu udaya wrote:
> Hello, Greetings !I am new to postgres and recently got migrated from oracle.I am trying to restore 9.5G database
(1GBdumpfile) which has 500 schemas with 1 lakh rows in each schema. Could take the data dump using pg_dump and it
takesaround 40 minutes. I tried to use pg_restore to restore this dump, but it takes hours to restore the dump. I have
usedthe configurations parameters as below: shared_buffers = 1024MB   work_mem = 512MBmaintenance_work_mem =
512MBwal_buffers= 100MB I have used command to restore as below:pg_Restore -d newdb -j2 e:\file.dmp My machine
configurationsare as below:Windows Core I5 with 4GB Ram. Thanks for your help. Thanks and RegardsRadha Krishna
                
 

You should better look for help on the pgsql-* mailing lists (for
example pgsql-general).

Anyway, from what you say, you should probably take a look at your
checkpoint settings. They probably hurt you more than you think.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com