Re: [GENERAL] port question

[DM]

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  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
>

Re: [GENERAL] port question

[John R Pierce]

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

[GENERAL] port question

[Amy Smith]

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