Postgres Pro
Downloads
Home   >   mailing lists

Re: port question - Mailing list pgsql-general

From DM
Subject Re: port question
Date
Msg-id eae6a62a1001250851q78a76f98p52f90f65ec0f2f08@mail.gmail.com
Whole thread Raw
In response to Re: port question  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: FTS uses "tsquery" directly in the query
Next
From: "Abraham, Danny"
Date:
Subject: Re: Log full of: statement_timeout out of the valid range.