Thread: port question

port question

From

Amy Smith

Date:

24 January 2010, 17:53:35

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

Re: port question

From

John R Pierce

Date:

24 January 2010, 18:23:47

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='*' ?

Re: port question

From

Date:

25 January 2010, 15:51:25

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:

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