Re: using psql after you change the default port - Mailing list pgsql-general

From David Kerr
Subject Re: using psql after you change the default port
Date
Msg-id 20091223000832.GB18657@mr-paradox.net
Whole thread Raw
In response to Re: using psql after you change the default port  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: using psql after you change the default port  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: using psql after you change the default port  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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@mr-paradox.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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: using psql after you change the default port
Next
From: "Joshua D. Drake"
Date:
Subject: Re: using psql after you change the default port