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

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 different port 5433 on
separate data directory but getting some errors.

- I replaced the default port with 5433 in the postgresql.conf file.

- We are not using Ubuntu , hence, I think we can’t use the
pg_cluster

./initdb -D /opt/PostgreSQL-10/whr_data1_5433 -U postgres -W

./pg_ctl -D /opt/PostgreSQL-10/whr_data1_5433 -l
/opt/PostgreSQL-10/whr_dlog/start.log start

Error while creating Cluster:

[postgres(at)ip-172-31-32-99 bin]$ cat /opt/PostgreSQL-10/whr_dlog/start.log

2022-07-18 13:11:14.404 UTC [13418] LOG: could not bind IPv4 address
"127.0.0.1": Address already in use

2022-07-18 13:11:14.404 UTC [13418] HINT: Is another postmaster already
running on port 5432? If not, wait a few seconds and retry.

2022-07-18 13:11:14.404 UTC [13418] WARNING: could not create listen
socket for "localhost"

2022-07-18 13:11:14.404 UTC [13418] FATAL: could not create any TCP/IP
sockets

2022-07-18 13:11:14.404 UTC [13418] LOG: database system is shut down

[postgres(at)ip-172-31-32-99 bin]$

On Mon, Jul 18, 2022 at 7:12 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> 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 therefore restores -- are
> always binary "whole cluster").
>
> --
> Angular momentum makes the world go 'round.
>