Re: More than one Cluster on single server (single instance)

2022-07-21 Thread Daulat
I have resolved this issue and it's working. Thanks On Thu, Jul 21, 2022 at 1:45 PM Daulat wrote: > Thanks for your inputs. > > We are thinking about this approach to consolidate some small applications > of individual clients and to perform administration (data/log/pgbackrest > backups etc.)

Re: More than one Cluster on single server (single instance)

2022-07-21 Thread Daulat
Thanks for your inputs. We are thinking about this approach to consolidate some small applications of individual clients and to perform administration (data/log/pgbackrest backups etc.) separately which is not possible on a single cluster. We have tried to create and start the cluster with differ

Re: More than one Cluster on single server (single instance)

2022-07-18 Thread Ron
On 7/18/22 04:46, Guillaume Lelarge wrote: Hi, [snip] It would make things easier for you to use a single cluster, and as many databases as you want in this cluster. It would make *PITR* restoration *of a single database* (or small set of databases) impossible (since such backups -- and ther

Re: More than one Cluster on single server (single instance)

2022-07-18 Thread Ron
On 7/18/22 02:55, Daulat wrote: Hello Team, We are planning to create multiple clusters on a single server (single instance) with PostgreSQL V.10 to run multiple applications. Version (9,6, 10, 111, 12...) does not matter. I don't know if it is a good idea to use a single machine to run n

Re: More than one Cluster on single server (single instance)

2022-07-18 Thread Mladen Gogala
On 7/18/22 03:55, Daulat wrote: Please share your thoughts on this approach? How can we create multiple clusters under a single postgres version? You can use Docker images. How can we identify/allocate the resources to parameters like shared_buffers, effective_cache_size, work_mem etc in cas

Re: More than one Cluster on single server (single instance)

2022-07-18 Thread Guillaume Lelarge
Hi, Le lun. 18 juil. 2022 à 09:55, Daulat a écrit : > > Hello Team, > > We are planning to create multiple clusters on a single server (single > instance) with PostgreSQL V.10 to run multiple applications. > > Planning to create a database cluster on a release 10 sounds already like a bad idea,

More than one Cluster on single server (single instance)

2022-07-18 Thread Daulat
Hello Team, We are planning to create multiple clusters on a single server (single instance) with PostgreSQL V.10 to run multiple applications. I don't know if it is a good idea to use a single machine to run n clusters but we are looking to minimize the cost of servers and other resources. Plea