I have resolved this issue and it's working. Thanks
On Thu, Jul 21, 2022 at 1:45 PM Daulat <daulat....@gmail.com> 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.) 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@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@ip-172-31-32-99 bin]$ > > On Mon, Jul 18, 2022 at 7:12 PM Ron <ronljohnso...@gmail.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. >> >
