Re: Queries in replica are failing

From: ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
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:20:46
Message-ID: CAKDb7aFYMCLVxzRb019UBRUt8oz1ux_KK+x4BGnY1NakcO_EXg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can I pause or stop the replication at a particular time in postgres RDS.?

On Fri, May 31, 2024 at 11:47 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> 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
>

--
Have a Good day !!!

Regards
Rohit Sachdeva

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wetmore, Matthew (CTR) 2024-05-31 18:49:20 Queries in replica are failing
Previous Message Laurenz Albe 2024-05-31 18:17:01 Re: Queries in replica are failing