Create a standby server

From: normandavis1990 <normandavis1990(at)proton(dot)me>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Create a standby server
Date: 2024-03-11 11:51:17
Message-ID: e7wKZVtesjLCiU0KkgL8YhjecAtJgdjCUm7mA05IwziSLXQxciKU7dtj9tzw_mvXuGNLBznonqQOs52mlTGtdUcO8xeFjqurjQkNdXFwCAk=@proton.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I have a master and tow standby servers. I want to create another one. These servers are made by someone else and I am a newbie in PostgreSQL.
I found the following two tutorials:

https://linuxconfig.org/how-to-create-a-hot-standby-with-postgresql

https://github.com/GoogleCloudPlatform/community/blob/master/archived/setting-up-postgres-hot-standby.md

A) Which on is better and easier?

B) In these articles, to create a Standby server, a user is created in the database. Because there are already two Standby servers, this user is probably created. How can I find it? Can I use that user to build a third server?

Cheers.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2024-03-11 11:56:31 Re: could not open file "global/pg_filenode.map": Operation not permitted
Previous Message Laurenz Albe 2024-03-11 11:10:31 Re: could not open file "global/pg_filenode.map": Operation not permitted