| From: | bhanu udaya <udayabhanu1984(at)hotmail(dot)com> |
|---|---|
| To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | pg_Restore |
| Date: | 2013-01-20 18:33:01 |
| Message-ID: | COL002-W91D920E81B347335FEE275D3100@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
Hello, Greetings !I am new to postgres and recently got migrated from oracle.I am trying to restore 9.5G database (1GB dumpfile) which has 500 schemas with 1 lakh rows in each schema. Could take the data dump using pg_dump and it takes around 40 minutes. I tried to use pg_restore to restore this dump, but it takes hours to restore the dump. I have used the 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 configurations are as below:Windows Core I5 with 4GB Ram. Thanks for your help. Thanks and RegardsRadha Krishna
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2013-01-20 21:36:57 | Re: Bug on pgAdmin III commit: Add a -V/--version CLI option? |
| Previous Message | Guillaume Lelarge | 2013-01-17 21:42:27 | Re: PgAdmin 1.16.1 - editing trigger function, should not close on "esc" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2013-01-20 18:37:21 | Re: proposal: fix corner use case of variadic fuctions usage |
| Previous Message | Kevin Grittner | 2013-01-20 17:19:12 | Re: not(t_xmax = 0) |