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
IpcMemoryCreate: shmget(key=5432001, size=85450752, 03600) failed: Invalid
argument
This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter. You can either
reduce the request size or reconfigure the kernel with larger
Hi Richard,Thank you very much for the information. The SHMMAX was set to 33554432, and that's why it failed to start the postmaster. Thanks for the link to the kernel resources article. I guess changing these parameters would require recompiling the kernel. Is there any work around
Thank you very much for the information. The SHMMAX was set to 33554432,
and that's why it
failed to start the postmaster. Thanks for the link to the kernel resources
article. I guess
changing these parameters would require recompiling the kernel.
Is there any work around without
Hi All,Thanks Richard for the additional link. The information is very useful.The restore completed successfully in 2.5 hours in the new 2GB box, with the same configuration parameters. I think if I can tweak the parameters a little more, I should be able to get it down to the 1 hr down
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 with512 MBRAM andhas 1
