Error in PE-PostgreSQL installation : Puppet

0 votes

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.

Jul 31 in Puppet by Namik
• 1,200 points
20 views

1 answer to this question.

0 votes

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!

answered Jul 31 by Sirajul
• 16,960 points

Related Questions In Puppet

0 votes
1 answer

Service already defines error in Puppet

Hey @Rohan, try this: class MyClass { ...READ MORE

answered Feb 9 in Puppet by Monish
34 views
0 votes
1 answer

Puppet: Error: Cannot set modulepath settings in puppet.conf

These extra module paths are specific to ...READ MORE

answered Aug 7 in Puppet by Sirajul
• 16,960 points
10 views
0 votes
1 answer
0 votes
1 answer

Ram requirements for puppet installation

4 GB would be less for proper ...READ MORE

answered Dec 19, 2018 in Puppet by Alan
20 views
+13 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 26, 2018 in DevOps & Agile by DragonLord999
• 8,380 points
111 views
0 votes
1 answer
0 votes
1 answer

Puppet : Provisioning a Replica in PE for High availability.

Provisioning a replica duplicates specific components and ...READ MORE

answered Aug 1 in Puppet by Sirajul
• 16,960 points
21 views
0 votes
1 answer