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, 2019 in Puppet by Namik
• 1,230 points

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, 2019 by Sirajul
• 59,070 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, 2019 in Puppet by Monish
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, 2019 in Puppet by Sirajul
• 59,070 points
0 votes
1 answer

Puppet: Error: Could not request certificate: getaddrinfo: Temporary failure in name resolution

You are getting this error because your ...READ MORE

answered Aug 8, 2019 in Puppet by Sirajul
• 59,070 points
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, 2019 in Puppet by Sirajul
• 59,070 points
+15 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,450 points
+2 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, 2019 in Puppet by Sirajul
• 59,070 points
0 votes
1 answer

Puppet: Error while trying to execute shell commands in Exec resource type

The default exec provider on *nix OSes ...READ MORE

answered Aug 2, 2019 in Puppet by Sirajul
• 59,070 points