Re: High Availability and Replication

Hi, Not required. Thanks & Regards, Abdul Sayeed PostgreSQL DBA Postgres Professional Certified Skype: abdul.sayeed24 On Sat, 2 Mar 2024 at 12:21 PM, normandavis1990 wrote: > > On Saturday, March 2nd, 2024 at 1:24 AM, Abdul Sayeed < > abdulsayee...@gmail.com> wrote: > > Hi, > > When Master

Re: High Availability and Replication

> On Saturday, March 2nd, 2024 at 1:24 AM, Abdul Sayeed > wrote: > Hi, > > When Master server goes down, either you need to promote one of slave node or > configure HA mechanism so that in case of master server goes down it will > automatically promote the slave server as new master. > > Patro

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, 2024, at 10:15 AM, David G. Johnston wrote: On Th

Re: High Availability and Replication

Hi, When Master server goes down, either you need to promote one of slave node or configure HA mechanism so that in case of master server goes down it will automatically promote the slave server as new master. Patroni HA tool would be good option for your requirement. https://patroni.readthedocs

Re: High Availability and Replication

> 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, 2024, at 10:15 AM, David G. Johnston >>> wrote: >>> >>> >>> >>> On Thursday, February 29, 2024, normandavis1990 >>

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 High Availability and Replication? >> >> The former is a

Re: High Availability and Replication

> On Feb 29, 2024, at 10:15 AM, 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 technique. Perhaps

Re: High Availability and Replication

On 2/29/24 12:02, normandavis1990 wrote: What does this technique do? https://www.postgresql.org/docs/current/high-availability.html On Thursday, February 29th, 2024 at 10:45 PM, David G. Johnston wrote: On Thursday, February 29, 2024, normandavis1990 mailto:normandavis1...@proton.me>>

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 technique. > > David J

RE: High Availability and Replication

m> office 949-754-1203 mobile 425-802-9603 From: David G. Johnston Sent: Thursday, February 29, 2024 11:15 AM To: normandavis1990 Cc: pgsql-general@lists.postgresql.org Subject: Re: High Availability and Replication CAUTION: This email originated from outside of the organization. Do not foll

Re: High Availability and Replication

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 technique. David J.