port question

Started by Amy Smithabout 16 years ago3 messagesgeneral
Jump to latest
#1Amy Smith
vah123@gmail.com

I have installed a v8.4 and first port using localhost is ok. but the second
one using different port will get error when connect using IP address.
Is that only one port is allowed for one server ?
please help - need expert's advice.

thanks
Amy

#2John R Pierce
pierce@hogranch.com
In reply to: Amy Smith (#1)
Re: port question

Amy Smith wrote:

I have installed a v8.4 and first port using localhost is ok. but the
second one using different port will get error when connect using IP
address.
Is that only one port is allowed for one server ?
please help - need expert's advice.

you can run different instances of postgresql on different ports as long
as their $PGDATA directories are different.

is this second server configured to LISTEN_ADDRESSES='*' ?

#3DM
dm.aeqa@gmail.com
In reply to: John R Pierce (#2)
Re: port question

Hello Amy,

trying to understand your situation,

*I have installed a v8.4 and first port using localhost is ok - *default
port is 5432

You can only use one port for one instance of postgres, default port 5432
can be overridden by any new port number.

Thanks
Deepak

On Sun, Jan 24, 2010 at 11:23 AM, John R Pierce <pierce@hogranch.com> wrote:

Show quoted text

Amy Smith wrote:

I have installed a v8.4 and first port using localhost is ok. but the
second one using different port will get error when connect using IP
address.
Is that only one port is allowed for one server ?
please help - need expert's advice.

you can run different instances of postgresql on different ports as long as
their $PGDATA directories are different.

is this second server configured to LISTEN_ADDRESSES='*' ?

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general