Re: using psql after you change the default port

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: using psql after you change the default port
Date: 2009-12-23 00:08:32
Message-ID: 20091223000832.GB18657@mr-paradox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 22, 2009 at 05:01:45PM -0700, Scott Marlowe wrote:
- On Tue, Dec 22, 2009 at 4:57 PM, David Kerr <dmk(at)mr-paradox(dot)net> wrote:
- > Howdy all
- >
- > I changed the default port for Postgresql.
- >
- > Now, when I want to access postgresql via psql (on the db server),
- > is there a way to make it default to the new port without using -p
- > or a .psqlrc file?
-
- You can set an envvar:
-
- export PGPORT=5433
-
- etc...

ok thanks, that might be an easier way to handle my scripts.

can you export PGHOST as well?

Dave

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-12-23 00:17:05 Re: using psql after you change the default port
Previous Message Joshua D. Drake 2009-12-23 00:06:46 Re: using psql after you change the default port