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
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
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