On Wed, 2023-11-22 at 16:55 +0000, Efrain J. Berdecia wrote: > Thanks, the issue we've run into, which I guess could be really a setup > issue, with running a COPY command while executing pg_restore, > is that if we are restoring a large table (bigger than 500GB) our WAL > directory can grow to be very large.
You can avoidwriting WAL if you set "wal_level = minimal", restart PostgreSQL and restore the dump with the --single-transaction option. Yours, Laurenz Albe
