817186 - Please audit all postgresql.conf files - compare to what is in puppet

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Selena Deckelmann :selenamarie :selena]

The stage postgresql.conf file was set to only respond to 'localhost' on port 5432. 

Please audit all postgresql.conf files and bring puppet fully in sync with production!

This is really important to do as soon as possible as troubleshooting the problems that result from incorrectly configured files is terrifying. There are over 300 distinct configuration variables in a postgres instance, and about five different things that contribute to authentication/login errors if set incorrectly. :(

Comment 1

[Matt Pressman [:mpressman]]

With the new puppet module, the config files are not picking up the previous files defined for clusters. I'm using the new format to ensure the proper config items with the new layout

Comment 2

[Matt Pressman [:mpressman]]

After our meeting yesterday and atoll pointing out that the postgresql.conf file being used was the default from the rpm and not the puppet generated one. I have confirmed that puppet is indeed using the correct config files defined for each cluster and while this isn't the long-term preferred solution, the work I did in pulling out each config value will be useful when we migrate to a single default template.

On irc, solarace mentioned there is some duplication in the puppet configs now and I will remove those and retest the puppet generated postgresql.conf files.

Comment 3

[Matt Pressman [:mpressman]]

All configs are good to go.

Comment 4

[(no longer active)]

https://hg.mozilla.org/mozilla-central/rev/812eb3fb9abe

Comment 5

[Ed Morley [:emorley]]

(In reply to Ehsan Akhgari [:ehsan] from comment #4)
> https://hg.mozilla.org/mozilla-central/rev/812eb3fb9abe

Ignore; meant for bug 817816.