Re: How to create directory format backup

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrus <kobruleht2@hot.ee>
Cc: depesz@depesz.com, pgsql-general <pgsql-general@postgresql.org>
Date: 2023-02-08T22:57:04Z
Lists: pgsql-general
Andrus <kobruleht2@hot.ee> writes:
> This file size is only 6.2 GB. If custom format is used, pg_dump creates 
> large file without problems. There are no file size limits. Error 
> message is not about this.

Are you certain that the pg_dump you're using is v15, and not something
pre-v14?  We got rid of the 4GB limit on stat() results in v14,
or so we thought.

Anyway, as far as I can find pg_dump can only reach that error message
via fsync_dir_recurse(), which suggests that a workaround might be
to add --no-sync so it doesn't try to fsync its output.

			regards, tom lane