On Mon, Dec 21, 2009 at 4:35 PM, Scott Marlowe <[email protected]>wrote:
> On Mon, Dec 21, 2009 at 2:26 PM, Scott Mead > <[email protected]> wrote: > > > > On Mon, Dec 21, 2009 at 4:17 PM, Scott Marlowe <[email protected]> > > wrote: > >> > > > Yeah, I create a different "admin" account for each one, that has the > PGPORT and stuff already set, and setup pg_hba.conf to reject the > admin accounts from other instances so I don't do anything too stupid. > The other useful trick is to change set your psql prompt (via .psqlrc) so that it shows which port the db you're logged into is listening on: \set PROMPT1 '%/:%>=%# ' This will give you a prompt of: postgres:5432=# Take a look at http://www.postgresql.org/docs/8.3/static/app-psql.html for more prompt options. --Scott
