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 1pPojI-0005tc-LI for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 17:59:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPojH-0001mI-Ho for pgsql-general@arkaria.postgresql.org; Wed, 08 Feb 2023 17:59:35 +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 1pPojH-0001m9-4a for pgsql-general@lists.postgresql.org; Wed, 08 Feb 2023 17:59:35 +0000 Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPojC-0000Fp-GR for pgsql-general@postgresql.org; Wed, 08 Feb 2023 17:59:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com; s=20170201; h=In-Reply-To:Content-Transfer-Encoding:Content-Type:MIME-Version :References:Reply-To:Message-ID:Subject:Cc:To:Sender:From:Date:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=c8rjYt/GeRS2EEQefkC/Jr53XVyqP3TLbBfckB8QMZg=; b=AuAklo+0/BreN9WxG8c4G1atLG zgBeNBpcbKnUamgWgmf3iudu1FNTl0CS3BNCMtwEzEiaTcQilQ6dFXhjRLgNe0MG1FuMFgXaL2JGZ Di23X5eBWwQeJ+QnjosU5CBJJfoI2dItU+2ynUEoKbBEQzQqvbzschbqLOZcZK+/oH/Q=; Received: from depesz by depesz.com with local (Exim 4.94.2) (envelope-from ) id 1pPoj8-00DaUY-UU; Wed, 08 Feb 2023 18:59:26 +0100 Date: Wed, 8 Feb 2023 18:59:26 +0100 From: hubert depesz lubaczewski Sender: depesz@depesz.com To: Andrus Cc: pgsql-general Subject: Re: How to create directory format backup Message-ID: Reply-To: depesz@depesz.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Feb 08, 2023 at 05:00:10PM +0200, Andrus wrote: > 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 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. Best regards, depesz