Security

(public)

User Story

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!

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.