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 t
> 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 w
Hi, Saranya,
Saranya Sivakumar wrote:
> 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.
As
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 witho
> 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 SH
