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 1pPrXm-0003e3-La for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 20:59:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPrXj-0003Nb-Ee for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 20:59:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPrXj-0003NS-2y for pgsql-general@lists.postgresql.org; Wed, 08 Feb 2023 20:59:51 +0000 Received: from portal-smtp-out.hot.ee ([194.126.101.125]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPrXc-00035c-4v for pgsql-general@postgresql.org; Wed, 08 Feb 2023 20:59:50 +0000 Received: from localhost (localhost [127.0.0.1]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id C7BE231B5; Wed, 8 Feb 2023 22:59:42 +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 a98KlsX1WWYN; Wed, 8 Feb 2023 22:59:40 +0200 (EET) Received: from mail.hot.ee (hot-relayhost2.estpak.ee [213.180.2.80]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 3BBCE319A; Wed, 8 Feb 2023 22:59:40 +0200 (EET) Content-Type: multipart/alternative; boundary="------------BfZC2gYhnqpkRLX85SkZmzGZ" Message-ID: <6da54c55-6752-ca53-cdc8-2342b2c75258@hot.ee> Date: Wed, 8 Feb 2023 22:59:43 +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 Subject: Re: How to create directory format backup Content-Language: et To: depesz@depesz.com Cc: pgsql-general References: From: Andrus In-Reply-To: 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. --------------BfZC2gYhnqpkRLX85SkZmzGZ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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. --------------BfZC2gYhnqpkRLX85SkZmzGZ Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit 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.


--------------BfZC2gYhnqpkRLX85SkZmzGZ--