public inbox for [email protected]
help / color / mirror / Atom feedQuery about pg_wal directory filled up
2+ messages / 2 participants
[nested] [flat]
* Query about pg_wal directory filled up
@ 2024-12-17 13:41 Rama Krishnan <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Rama Krishnan @ 2024-12-17 13:41 UTC (permalink / raw)
To: pgsql-general
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.
As I understand, once the `pg_wal` directory is completely filled, the
database will allow only read queries and will not permit any write
operations.
Kindly advise
Thanks
RK
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Query about pg_wal directory filled up
@ 2024-12-19 00:00 Saul Perdomo <[email protected]>
parent: Rama Krishnan <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Saul Perdomo @ 2024-12-19 00:00 UTC (permalink / raw)
To: Rama Krishnan <[email protected]>; +Cc: pgsql-general
On Wed, Dec 18, 2024, 5:01 a.m. Rama Krishnan <[email protected]> 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:
https://pgbackrest.org/
> Kindly advise
>
>
> Thanks
> RK
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-12-19 00:00 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-12-17 13:41 Query about pg_wal directory filled up Rama Krishnan <[email protected]>
2024-12-19 00:00 ` Saul Perdomo <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox