Error in PE-PostgreSQL installation Puppet

Question

I have installed Puppet Enterprise on my linux machine and since the load on PuppetDB will be huge, i am trying to install standalone PE-PostgreSQL. The database installation fails.

/var/log/pe-postgresql/pgstartup.log shows the error:

FATAL: could not create shared memory segment: No space left on device 
DETAIL: Failed system call was shmget(key=5432001, size=34427584512,03600).

How do i resolve this? Please help.

Answer 1

When installing PE on machines with large amounts of RAM, the PostgreSQL database might use more shared buffer memory than is available.

The above error log signifies that PostgreSQL buffer memory causes installation to fail.

• On the master, set the shmmax kernel setting to approximately 50% of the total RAM.

• Set the shmall kernel setting to the quotient of the new shmmax setting divided by the page size. 

• You can confirm page size by running

 getconf PAGE_SIZE

• Set the new kernel settings:

sysctl -w kernel.shmmax=<your shmmax calculation>
sysctl -w kernel.shmall=<your shmall calculation>

This will resolve it!