I have 2 instances of PostgreSQL running on some servers. One on the default port (5432) and the other instance on port 5433. Some users (and processes) only need access to the second instance (5433) and I'd like to set it up so that when those users use commands like
createdb in their shell it will automatically direct them to the right Postgres instance instead of them having to type
-p 5433 along with every command.
I tried to look this up on www.postgresql.org but was unable to find it...probably my fault. Anyone know how?