https://www.percona.com/blog/managing-multiple-postgresql-instances-on-ubuntu-debian/ Wed, 30 Oct 2019 15:02:56 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/managing-multiple-postgresql-instances-on-ubuntu-debian/#comment-10971338 Wed, 30 Oct 2019 15:02:56 +0000 https://www.percona.com/blog/?p=57826#comment-10971338 Hi Omar, are you are asking about multi-host PostgreSQL server clusters?. If that is the case, clients may need a proxy which can be configured using HAProxy OR same can be achieved using multi-host connection string which we are already blogged about.
“cluster” is a word used in PostgreSQL world in multiple meaning, if the question is about single host, each PostgreSQL instance will be available in different ports and each will have their own pg_hba.conf file.

]]> https://www.percona.com/blog/managing-multiple-postgresql-instances-on-ubuntu-debian/#comment-10971315 Fri, 25 Oct 2019 14:40:34 +0000 https://www.percona.com/blog/?p=57826#comment-10971315 Hi Jobin Augustine, how can I access all clusters in differents clients inside my network, pg_hba.conf not work for clusters.

]]> https://www.percona.com/blog/managing-multiple-postgresql-instances-on-ubuntu-debian/#comment-10970917 Mon, 24 Jun 2019 15:16:21 +0000 https://www.percona.com/blog/?p=57826#comment-10970917 Interesting! mysqld_multi is a very old and well known binaries to manage multiple instances of mysql service running on the same server, we do use for our spoof envs. Good to have similar tool on Postgres as well but the only thing is we would have a redundant configuration whereas on mysqld_multi it’s inherited from the default block if not specified. Nice ?

]]>