Re: How to create directory format backup

Andrus <kobruleht2@hot.ee>

From: Andrus <kobruleht2@hot.ee>
To: depesz@depesz.com
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2023-02-08T20:59:43Z
Lists: pgsql-general
Hi!

 >Looks like your filesystem on client is having limits on file sizes. 
Use better filesystem, or just dump on linux, it's filesystems usually 
don't hit these limits.

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.

Backup client is running in Windows 11 and this cannot changed.

How to create backup in format from which tables can selectively restored?

Posted also in 
https://stackoverflow.com/questions/75387616/how-to-make-directory-format-backup

Andrus.