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,210 points
30 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
• 39,540 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
59 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
• 39,540 points
114 views
0 votes
1 answer
0 votes
1 answer

Puppet in Docker: Error while running the Puppet container

Try to uncomment the following lines in the definition ...READ MORE

answered Aug 19 in Puppet by Sirajul
• 39,540 points
24 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
219 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
• 39,540 points
99 views
0 votes
1 answer