Please fix $PATH of postgres user on DB servers

VERIFIED FIXED

Status

Socorro
Database
VERIFIED FIXED
6 years ago
6 years ago

People

(Reporter: jberkus, Assigned: mpressman)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

6 years ago
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!
(Reporter)

Comment 1

6 years ago
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?
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.
(Reporter)

Comment 3

6 years ago
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

6 years ago
Hey Matt, can we get this sorted out (and bug 747238)?
(Assignee)

Comment 5

6 years ago
https://bugzilla.mozilla.org/show_bug.cgi?id=742127#c1
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
(Reporter)

Comment 6

6 years ago
Looks good, thanks!
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.