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!
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.
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
Hey Matt, can we get this sorted out (and bug 747238)?
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
Looks good, thanks!
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.