Horton
Menu

How to create directory format backup

Andrus <kobruleht2@hot.ee>

View thread
From: Andrus <kobruleht2@hot.ee>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2023-02-08T15:00:10Z
Lists: pgsql-general 
Hi!

Creating backup in directory format using

     pg_dump -f "sba" -Fdirectory --jobs=32 --verbose sba

throws error

     pg_dump: error: could not stat file "sba/282168.data.gz": value too 
large

How to fix it ?

Server is Postgres 12 running in Debian Linux 10 under WSL
Client is pg_dump from Postgres 15 running in Windows 11

Andrus