Re: setting up streaming replication

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Brad White <b55white(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: setting up streaming replication
Date: 2023-10-24 18:37:04
Message-ID: 587165B2-19D4-4C11-90AB-85DED9CCC70B@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Oct 24, 2023, at 11:31, Brad White <b55white(at)gmail(dot)com> wrote:
> Are you saying that once I get streaming replication set up, it quits working when I reboot the servers once a week?

Not unless the downtime is sufficiently long that the replica can't find the WAL information it needs. You can avoid this with PostgreSQL settings, but you might also consider keeping a WAL archive in a cloud storage system like S3 (it can be combined with backups, using a tool like pgBackRest).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-10-24 19:59:29 Re: setting up streaming replication
Previous Message Brad White 2023-10-24 18:31:47 Re: setting up streaming replication