Re: How to choose new master from slaves.?

2022-08-06 Thread Ron
On 8/6/22 15:45, Peter J. Holzer wrote: On 2022-08-06 15:06:06 -0500, Ron wrote: On 8/6/22 03:40, Peter J. Holzer wrote: Using sync replication on an unstable link is probably not a good idea. Every time the link goes down, A freezes. Is this what you want? I had to fight my end users about

Re: How to choose new master from slaves.?

2022-08-06 Thread Peter J. Holzer
On 2022-08-06 15:06:06 -0500, Ron wrote: > On 8/6/22 03:40, Peter J. Holzer wrote: > > Using sync replication on an unstable link is probably not a good idea. > > Every time the link goes down, A freezes. Is this what you want? > > I had to fight my end users about how to replicate a SQL Server

Re: How to choose new master from slaves.?

2022-08-06 Thread Ron
On 8/6/22 03:40, Peter J. Holzer wrote: On 2022-08-04 07:43:28 +, Sacheen Birhade wrote: I have a very basic question about streaming replication feature of Postgres. Let’s assume I have servers A, B, C, D, & E with postgres installed with streaming replication as follow: A à B ( sync

Re: How to choose new master from slaves.?

2022-08-06 Thread Peter J. Holzer
On 2022-08-04 07:43:28 +, Sacheen Birhade wrote: > I have a very basic question about streaming replication feature of Postgres. > Let’s assume I have servers A, B, C, D, & E with postgres installed with > streaming replication as follow: > A à B ( sync replication ) > A à C ( async

Re: How to choose new master from slaves.?

2022-08-04 Thread Ron
On 8/4/22 02:43, Sacheen Birhade wrote: Hi All, I have a very basic question about streaming replication feature of Postgres. Let’s assume I have servers A, B, C, D, & E with postgres installed with streaming replication as follow: A à B ( sync replication ) A à C ( async replication ) A

How to choose new master from slaves.?

2022-08-04 Thread Sacheen Birhade
Hi All, I have a very basic question about streaming replication feature of Postgres. Let's assume I have servers A, B, C, D, & E with postgres installed with streaming replication as follow: A --> B ( sync replication ) A --> C ( async replication ) A --> D ( async replication ) A --> E