Re: Bash profile

Create a bash function that exports PGDATA to the relevant directory, based on the parameter you pass.

Add as much error checking (to ensure that the parameter you passed actually points to a real data dir and that the postmaster is running.  How you do that depends on whether it's Debian-based, RH-based or something else.

We, for example, have standardized on data directories in the format:

/Database/<MajorVer>/data

Thus, something as simple as this would work for us:

pgswitch() { export PGDATA=/Database/${1}/data ; }