Re: pg_restore causing ENOSPACE on the WAL partition - Mailing list pgsql-general

From Dimitrios Apostolou
Subject Re: pg_restore causing ENOSPACE on the WAL partition
Date
Msg-id 34bc1ed2-4b06-2172-e4f0-2c85bf6208c5@gmx.net
Whole thread Raw
In response to pg_restore causing ENOSPACE on the WAL partition  (Dimitrios Apostolou <jimis@gmx.net>)
List pgsql-general
Forgot an important setting I have during pg_restore:

On Thu, 10 Apr 2025, Dimitrios Apostolou wrote:

> max_wal_size=64GB
> max_replication_slots = 0
> max_logical_replication_workers = 0
> max_wal_senders = 0
> wal_level = minimal
> autovacuum = off

checkpoint_completion_target = 0

so the checkpoint should finish ASAP and any delays are purely because of
I/O limitations. And for the sake of completion:

checkpoint_timeout = 600s


Regards,
Dimitris



pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
Next
From: Achilleas Mantzios
Date:
Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm