Postgres Pro
Downloads
Home   >   mailing lists

Re: Query about pg_wal directory filled up - Mailing list pgsql-general

From Saul Perdomo
Subject Re: Query about pg_wal directory filled up
Date
Msg-id CAN3jBgFTeXD2c+nejM9zvi1tG=CNuChqdU0C8cegc0j3B453MQ@mail.gmail.com
Whole thread Raw
In response to Query about pg_wal directory filled up  (Rama Krishnan <raghuldrag@gmail.com>)
List pgsql-general
Tree view


On Wed, Dec 18, 2024, 5:01 a.m. Rama Krishnan <raghuldrag@gmail.com> wrote:

Hi Team,

One of our clients recently migrated from Oracle to PostgreSQL and is conducting multiple scenarios to understand PostgreSQL behavior.  

One of their main concerns is whether the database will allow `INSERT` queries when the `pg_wal` directory becomes full.  


The way out of this "conundrum" is to make sure to implement a solid backup process. 

I'm a huge fan of PGBackRest:




Kindly advise


Thanks
RK

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
Next
From: Saul Perdomo
Date:
Subject: Re: How to deal with dangling files after aborted `pg_restore`?