742127 - Please fix $PATH of postgres user on DB servers

Status: VERIFIED FIXED

(Socorro :: Database, task)

Description

[[:jberkus] Josh Berkus]

Matt,

Recently, possibly as a consequence of running updates on servers, the custom .bash_profile and $PATH of the postgres user has been expunged from the various PostgreSQL servers, including the production server.

This means that, for example, a pg_dump command no longer works because it points to the 8.4.7 pg_dump from the default RH install.  The postgres user needs to have this in its profile:

PATH=/user/pgsql-9.0/bin:$PATH
PGDATA=/pgdata/9.0/data

I can't think why this would have been wiped out, except that it's under puppet, which is why I'm asking you instead of fixing it myself.  Thanks!

Comment 1

[[:jberkus] Josh Berkus]

BTW, we need this on all of the following servers:

master01
master02
stageDB
dev.dmz

Presumably the ~postgres config for devDB is a bit more complicated; mpressman?

Comment 2

[Sheeri Cabral [:sheeri]]

I added the postgres user in puppet, hopefully I did it properly. The .bash_profile for the postgres machines should be set now, and after 30-60 minutes things should propagate. If it doesn't, let me know and I'll see what I did wrong.

Comment 3

[[:jberkus] Josh Berkus]

This is not fixed on master01.  It is fixed on stageDB.

I can't verify either devdb or dev.dmz due to related bug: 747238

Comment 4

[Laura Thomson :laura]

Hey Matt, can we get this sorted out (and bug 747238)?

Comment 5

[Matt Pressman [:mpressman]]

https://bugzilla.mozilla.org/show_bug.cgi?id=742127#c1

Comment 6

[[:jberkus] Josh Berkus]

Looks good, thanks!