Re: Postgresql 9.5: Streaming Replication: Secondaries Fail To Start Post WAL Error

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgresql 9.5: Streaming Replication: Secondaries Fail To Start Post WAL Error
Date: 2024-05-28 21:24:56
Message-ID: CANzqJaCjb=bNSF7mrxFJ8DmCfqG2nTz_FHS8dTZjHpumcUe35Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 28, 2024 at 3:11 PM Johannes Truschnigg <
johannes(at)truschnigg(dot)info> wrote:

> On Tue, May 28, 2024 at 03:00:23PM -0400, Mohan NBSPS wrote:
> > [...]
> > Thank you Johannes for the advice.
> >
> > We are looking at moving to 16.
> > We did not implement slots to avoid disk space issues on primary
> (possible
> > network disconnect may fill up primary `pg_xlog`).
>
> Yes, replication slots can interrupt your primary.
>

Please define "interrupt". Using a replication slot, I thought files would
just accumulate in pg_wal while the replica is down (or the network is
slow, or the replica can't keep up with the primary).

Disaster, of course, when that disk fills up, but that's always been the
case.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Craig Milhiser 2024-05-29 00:59:09 Re: Pg_squeze
Previous Message Mohan NBSPS 2024-05-28 19:24:33 Re: Postgresql 9.5: Streaming Replication: Secondaries Fail To Start Post WAL Error