Re: Create a standby server

to your new replica server. > If you prefer to use replication slots you may also add -C -S to > get a replication slot created automatically by pg_basebackup. > > Good luck! > > Cheers, > Mateusz > > pon., 11 mar 2024 o 12:51 normandavis1990 > napisał(a): > >> H

Re: Create a standby server

> On Monday, March 11th, 2024 at 3:43 PM, Stephen Frost > wrote: > Greetings, > > * normandavis1990 (normandavis1...@proton.me) wrote: > > > I have a master and tow standby servers. I want to create another one.  > > These servers are made by someone else a

Create a standby server

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/co

Re: High Availability and Replication

server as new master. > > Patroni HA tool would be good option for your requirement. > > https://patroni.readthedocs.io/en/latest/README.html > > Hope this helps. > > Thanks & Regards, > Abdul Sayeed > PostgreSQL DBA > > On Sat, 2 Mar 2024 at 2:15 AM, Israel Brewst

Re: High Availability and Replication

> On Saturday, March 2nd, 2024 at 12:14 AM, Israel Brewster > wrote: >> On Mar 1, 2024, at 11:36 AM, normandavis1990 >> wrote: >> >>> On Thursday, February 29th, 2024 at 11:38 PM, Israel Brewster >>> wrote: >> >>>> On Feb 29, 202

Re: High Availability and Replication

> On Thursday, February 29th, 2024 at 11:38 PM, Israel Brewster > wrote: >> On Feb 29, 2024, at 10:15 AM, David G. Johnston >> wrote: >> >> On Thursday, February 29, 2024, normandavis1990 >> wrote: >> >>> What is the difference between Hig

How to clone a database?

Hello, I have a primary server with two replication servers. I want to HA this primary server because I need to shut it down. Please introduce me to a tutorial that explains this step by step. Could setting up HA cause the primary server to go down? Cheers.

Re: High Availability and Replication

What does this technique do? On Thursday, February 29th, 2024 at 10:45 PM, David G. Johnston wrote: > On Thursday, February 29, 2024, normandavis1990 > wrote: > >> What is the difference between High Availability and Replication? > > The former is a goal, the later is a

High Availability and Replication

Hello, What is the difference between High Availability and Replication? Cheers.

Moving PostgreSQL servers to a new server

Hi, I am new to PostgreSQL. My scenario is as follows: https://cdn.bloghunch.com/uploads/uNxNoi5uVKeDibd5.webp I have a Master server and two Replica (Replica-1 and Replica-2) servers. One of these Replica servers is in read-only mode and a report is prepared from it using Microsoft PowerBI. Du