Hi Clayton,
From what I remember, using -p will change BOTH the TCP/IP port and the
Unix domain socket.
i.e. pg_ctl start -o '-i -p 7777'
Should make PostgreSQL listen on TCP port 7777, and on most unix systems
will create a socket file in /tmp/.s.PGSQL.7777 (and its corresponding
lock file).
Regards and best wishes,
Justin Clift
Clayton Vernon wrote:
>
> Thanks, but can I specify each port? I've only seen the one documented
> command option "-p" which I assume was for the TCP/IP port.
>
> Again, thanks for the help,
>
> Clayton
>
> ----- Original Message -----
> From: "Doug McNaught" <doug@wireboard.com>
> To: "Clayton Vernon" <cvernon@enron.com>
> Cc: "John Oakes" <john@networkproductions.net>;
> <pgsql-general@postgresql.org>
> Sent: Thursday, April 26, 2001 6:19 PM
> Subject: Re: [GENERAL] JDBC speed question.
>
> > "Clayton Vernon" <cvernon@enron.com> writes:
> >
> > > Related question: how do you run postgreSQL to simultaneously support a
> Unix
> > > socket and TCP/IP?
> >
> > Just add '-i' to the postmaster startup options. The Unix socket will
> > still be available.
> >
> > -Doug
> > --
> > The rain man gave me two cures; he said jump right in,
> > The first was Texas medicine--the second was just railroad gin,
> > And like a fool I mixed them, and it strangled up my mind,
> > Now people just get uglier, and I got no sense of time... --Dylan
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi