Re: Queries in replica are failing

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
Cc: Siraj G <tosiraj(dot)g(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Queries in replica are failing
Date: 2024-05-31 18:17:01
Message-ID: 5c73f68597098635fe0f09b0f57ea8c1c85403a0.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2024-05-31 at 23:37 +0530, ROHIT SACHDEVA wrote:
> On Thu, May 30, 2024 at 11:37 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
> > Sure, WAL will pile up on the standby if it cannot be replayed right away.
> >
> > You could stop replication, but then WAL would pile up on the primary server.
> >
> > You have to keep the information somewhere.
>
> So What will be the work around for this.

Get more disk space, or perform less work on the database.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ROHIT SACHDEVA 2024-05-31 18:20:46 Re: Queries in replica are failing
Previous Message ROHIT SACHDEVA 2024-05-31 18:07:46 Re: Queries in replica are failing