Fwd: Creating multiple instances of postresql on Windows environment
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.
Please help me to resolve the issue.
Attachments:
Import Notes
Reply to msg id not found: PN1PR01MB01268D585A82E1C82F83BB9FF2A70@PN1PR01MB0126.INDPRD01.PROD.OUTLOOK.COMReference msg id not found: CALb1ETMQnHymfFTZZcr5qs3LJmxbsEk4h1DLua1qhUFzw43X2Q@mail.gmail.comReference msg id not found: PN1PR01MB01268D585A82E1C82F83BB9FF2A70@PN1PR01MB0126.INDPRD01.PROD.OUTLOOK.COM
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@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 08/11/2016 03:27, 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.Please help me to resolve the issue.
Hi, I am not sure of your requirements but you can alternatively run a
single database cluster with multiple databases. So run the cluster on a
single port as in the vanilla windows installation, and then use "CREATE
DATABASE dbname;" for each database you need.
Ignore this if it is not what you are asking :)
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@aklaver.com>
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 started2) 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@aklaver.com
--
Kaus2bh Kelkar
On Tue, Nov 15, 2016 at 10:49:42AM +0530, kaustubh kelkar wrote:
The issue is not with server , it is running fine .
Issue is not with port either , for local machine,
The issue is with:
I guess [...]
Regards,
Karsten
firewall won't affect.
On Tue, Nov 8, 2016 at 8:14 PM, Adrian Klaver <adrian.klaver@aklaver.com>
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 started2) 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@aklaver.com--
Kaus2bh Kelkar
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 11/15/2016 12:31 AM, Karsten Hilbert wrote:
On Tue, Nov 15, 2016 at 10:49:42AM +0530, kaustubh kelkar wrote:
The issue is not with server , it is running fine .
Issue is not with port either , for local machine,The issue is with:
I guess [...]
Regards,
Karsten
I have no idea what you're saying ...
--
john r pierce, recycling bits in santa cruz
The issue is not with server , it is running fine .
Issue is not with port either , for local machine,The issue is with:
I guess [...]I have no idea what you're saying ...
I figured the firewall might be an issue. Or it might not.
But guessing won't tell.
Regards,
Karsten
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general