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,210 points
39 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, 2019 by Sirajul
• 45,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, 2019 in Puppet by Monish
78 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, 2019 in Puppet by Sirajul
• 45,960 points
177 views
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
• 45,960 points
234 views
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
• 45,960 points
35 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,400 points
304 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, 2019 in Puppet by Sirajul
• 45,960 points
149 views
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
• 45,960 points
271 views