Re: [PERFORM] 7.3.2 pg_restore very slow

2006-08-07 Thread Richard Huxton
Saranya Sivakumar wrote: Hi All, I am trying to back up a full copy of one of our databases (14G) and restore it on another server. Both databases run 7.3.2 version. Though the restore completed successfully, it took 9 hours for the process to complete. The destination server runs Fedora Core 3

Re: [PERFORM] 7.3.2 pg_restore very slow

2006-08-07 Thread Saranya Sivakumar
Hi Richard,Thank you very muchfor the suggestions. As I said, we are stuck with 7.3.2 version for now. We have a Upgrade Project in place, but this backup is something we have to do immediately (we do not have enough time to test our application with 7.3.15 :( )The checkpoint segments

Re: [PERFORM] 7.3.2 pg_restore very slow

2006-08-07 Thread Saranya Sivakumar
Hi All,I tried to set shared_buffers= 1, turned off fsyncand reload the config file. But I got the following error:IpcMemoryCreate: shmget(key=5432001, size=85450752, 03600) failed: Invalid argument This error usually means that PostgreSQL's request for a shared memorysegment