Thread: Running two postgresql servers in same Ubuntu machine

Running two postgresql servers in same Ubuntu machine

From
"Geo P.C."
Date:
Please let us know  in an Ubuntu 14.04 Machine is it possible to run same Postgresql 9.4 Instances in same machine with different ports.

We installed Postgresql 9.4 in two ubuntu servers and now we need to configure Slave servers for these two servers. So in a third Ubuntu server we installed Postgresql 9.4 running on port 5432 and configured as slave server.

Now is it possible to install PostgreSQL 9.4 server on this server that runs on port 5433 so that we can configure second slave server on this machine itself.

Can anyone please help us on it.

Thanks
Geo

Re: Running two postgresql servers in same Ubuntu machine

From
David Osborne
Date:
I'm more familiar with Debian, but I think Ubuntu makes available the pg_createcluster command?
Have a look - it allows you to create multiple clusters on different ports.

On 6 July 2015 at 05:24, Geo P.C. <pcgeopc@gmail.com> wrote:
Please let us know  in an Ubuntu 14.04 Machine is it possible to run same Postgresql 9.4 Instances in same machine with different ports.

We installed Postgresql 9.4 in two ubuntu servers and now we need to configure Slave servers for these two servers. So in a third Ubuntu server we installed Postgresql 9.4 running on port 5432 and configured as slave server.

Now is it possible to install PostgreSQL 9.4 server on this server that runs on port 5433 so that we can configure second slave server on this machine itself.

Can anyone please help us on it.

Thanks
Geo



Re: Running two postgresql servers in same Ubuntu machine

From
Kiki Sugiaman
Date:
You can modify postgresql.conf on the second [cluster's] datadir and set
"port = 5433".