Postgres Pro
Downloads
Home   >   mailing lists

How to create directory format backup - Mailing list pgsql-general

From Andrus
Subject How to create directory format backup
Date
Msg-id b27a73f5-e6e6-4076-eee6-e002528d942c@hot.ee
Whole thread Raw
Responses Re: How to create directory format backup  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Index scan for PK constraint validation
Next
From: "sunyucong@gmail.com"
Date:
Subject: Re: Need help debugging slow logical replication