Search Postgresql Archives

Re: Fwd: Creating multiple instances of postresql on Windows environment

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

The issue is not with server , it is running fine .
Issue is not with port either , for local machine,  I guess firewall won't affect. 


On Tue, Nov 8, 2016 at 8:14 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 11/07/2016 07:27 PM, kaustubh kelkar wrote:

Hi ,____

I am a PostgreSQL user who wants to create multiple instances of
PostgreSQL database server. I am using PostgreSQL 9.4 and above. ____

I tried to create more than 2 instances on Linux environment in which I
was successful. But, for windows environment, I tried with the help of
pgAdmin4 and with the help of commands (initdb and some more commands.)
In both cases , there is some issue related to the ports. Please find
the attached screenshot for the reference.

To run more then one instance of Postgres on one machine each needs its own port. Have you done that?

The screenshot indicates a different problem, namely pgAdmin(?) cannot find a running server on port 5434 on the localhost. There can be several reasons for this:

1) The server is not running, eg the start up script failed.
        Solution: Verify the server has actually started

2) The server is not running on localhost.
        Solution: Verify where it is hosted.

3) It is running on localhost but not on port 5434.
        Solution: Verify that the port variable in postgresql.conf for that instance is set to 5434 and that the server was restarted to see the change.

3) It is running and is using port 5434, but a firewall rule is blocking access.
        Solution: Check whether you have a firewall running and whether it is blocking port 5434.


__ __

Please help me to resolve the issue.
____

__ __







--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx



--
Kaus2bh Kelkar

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux