Re: using psql after you change the default port

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: using psql after you change the default port
Date: 2009-12-23 00:06:46
Message-ID: 1261526806.3532.32.camel@jd-desktop.unknown.charter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2009-12-22 at 15:57 -0800, David Kerr 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?
>

Not that I know of.

> I sort of assumed that psql connected via a local pipe and not a port.

The socket is named... .s.PGSQL.<port>, thus it still needs to know.

Joshua D. Drake

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Kerr 2009-12-23 00:08:32 Re: using psql after you change the default port
Previous Message Scott Marlowe 2009-12-23 00:01:45 Re: using psql after you change the default port