Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPlvr-0007Xy-7j for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 15:00:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPlvp-0004wP-Na for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 15:00:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPlvp-0004wG-Bz for pgsql-general@lists.postgresql.org; Wed, 08 Feb 2023 15:00:21 +0000 Received: from portal-smtp-out.hot.ee ([194.126.101.125]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPlvh-00075j-SF for pgsql-general@postgresql.org; Wed, 08 Feb 2023 15:00:20 +0000 Received: from localhost (localhost [127.0.0.1]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 75EBC253D for ; Wed, 8 Feb 2023 17:00:09 +0200 (EET) X-Virus-Scanned: Debian amavisd-new at vm-hot-relay10.estpak.ee Received: from portal-smtp-out.hot.ee ([127.0.0.1]) by localhost (vm-hot-relay10.estpak.ee [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id BnhRypaCQ-Eo for ; Wed, 8 Feb 2023 17:00:07 +0200 (EET) Received: from mail.hot.ee (hot-relayhost3.estpak.ee [213.180.2.81]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 3D146249A for ; Wed, 8 Feb 2023 17:00:07 +0200 (EET) Content-Type: multipart/alternative; boundary="------------yhPz8J2Fv1liWd5StkeKLG7K" Message-ID: Date: Wed, 8 Feb 2023 17:00:10 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.6.1 Content-Language: et To: pgsql-general From: Andrus Subject: How to create directory format backup List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------yhPz8J2Fv1liWd5StkeKLG7K Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 --------------yhPz8J2Fv1liWd5StkeKLG7K Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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

--------------yhPz8J2Fv1liWd5StkeKLG7K--