Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u2qlH-006pVx-Hv for pgsql-general@arkaria.postgresql.org; Thu, 10 Apr 2025 12:12:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u2qlF-00Ay6C-Rh for pgsql-general@arkaria.postgresql.org; Thu, 10 Apr 2025 12:12:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u2qlF-00Ay64-GY for pgsql-general@lists.postgresql.org; Thu, 10 Apr 2025 12:12:01 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u2qlD-004WET-2U for pgsql-general@lists.postgresql.org; Thu, 10 Apr 2025 12:12:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1744287118; x=1744891918; i=jimis@gmx.net; bh=uT4S9mIphAC3ClmrrGkSLW3qeu0/y/69M2w8lARMDWs=; h=X-UI-Sender-Class:Date:From:To:Subject:In-Reply-To:Message-ID: References:MIME-Version:Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=dBpXsf27svXKUvlex/kCIOHaogxPRedMEtIRWlR/uVSB9KKPNdj2lXh2IIcOLG+S wuJ/bHuc2PjhPOE7Bpazi3slhFj6aiYMpo8EsnckzvrgBuHMAtFcppSn986x8kvD+ /qYaOfZ6kyP6FlCM+Kh11M30iKduFH17Z9hGemFY3eyhWzmwglmYncLRlVIc+F1s9 6C57NS8xyxQc7kHRT5X3iGk8CFdrS++BlLfpFs9yBYWiMUpuasVbCeT1etT+tQWsk ssYtDxXUgy0w8xEmrU30BfCTfYOt8a11gV4LFrcx4aI2dBf2RVz39eOpGGYTRDKON xnTSlwbRN6XuUaiVPg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from qtjimis-OpenSUSE-2.lan ([84.215.109.181]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MGyxN-1tom9F2zYJ-008iwn for ; Thu, 10 Apr 2025 14:11:58 +0200 Date: Thu, 10 Apr 2025 14:11:57 +0200 (CEST) From: Dimitrios Apostolou To: pgsql-general@lists.postgresql.org Subject: Re: pg_restore causing ENOSPACE on the WAL partition In-Reply-To: <076464ad-3d70-dd25-9e8f-e84f27decfba@gmx.net> Message-ID: <34bc1ed2-4b06-2172-e4f0-2c85bf6208c5@gmx.net> References: <076464ad-3d70-dd25-9e8f-e84f27decfba@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed X-Provags-ID: V03:K1:kftEuhYtwt3hxMu8zu7wYPEKWBiq7CFOwCswJK8UoEtCWhouDzx UQJ5rNjttpu7YTsVWzmEaFN4EXD78Sbm/IW4JACAhNO5PoDcV98bJTBhF0XEB+oEFj0K+e8 izYy+EZddmJLSSLrVv/MVPJNR899Md4GbtPyOuuOjSliy6iRUEAow+fiGTq97L6X8kBcSdJ GXnVlc3K4nG7DB9UCkzwQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:h1xpr0Y9YXM=;b4YL1h8FGpyoDyYgyD2T107NRth eeFUuYbf2zYnAQJghu+fUAJRDZueLZTGyjxhorlwgPr4TJOosIo4zMNzNueckI07uAvQKChIV LQCa0L8rqzu5f/7GN/pwztoA3TTkvZmy2SaU8cWj1F0kxvk6HsQSDrn/AwY2bQkYQbvVUWhD/ oxJRsyMNqItiyS7TI8H/Re/xyTNlS9JmHH/MNwu9gXPSi3HFzpJtYrKGR104tX2ymd2cAo3s9 U3367WjvfnTNwLpnUIwR3Et2Q0eoQetoLSDZ0rrVDQ4VzCnee5YyAFvY/5D0yA59AUXtNyQ3/ 0dPOgdIJZfQ9M8akwxYf6vCO4xQavUm5KCDcpLBi4UDpq2HydPw69Srs4/CLlqHHs2sz08X9B 8qHlgue6/NT5RozQIJJRGnSEh+ega9tM2v/gxL3DrweTu6/mG1hYGvm3eaZZgEWCoGwRFUcPC KMNt5QKtK83MoD6ItQJ2nl2zIu/xkj2K/DhIY3iTkP9f/W7TqFzDCmRkMAL/MtrxTnv1CZAWg hHOGVk5494GXoK5UbpxgJgxlwTin4y0pZJizQYuizteC6oJXuFoQpRlF/vDzL+bK+bndQHAvp HzLv23Qjixv+eypkh/ZPX97V6hv8f9QN4WTU51LS8crvn+zJmaq3wqzIk5W4VuZyu2f6Ict++ tWNP6HA2YNHhrabB3W5KiuHVUESo3PeKGWnbyOofd3ZjhW1UcQTy+A+babKYA85Amq4s0jklZ mFo6IwytEUz1tpwulklKqTfDq7GlQuZEQze6Yl3rN114U/zQoleQ0CB1LynfINZg2i7NscQHf C1uBx1cp72UgscdAC/P3zbv8WmP7c8xfsSdSKWNw4U/aBBj4ZperdwdjgVsejhXFsqwzZ7qZx oEWLzWl8w4qgzkhgCTqt08/JoJt+kjTgc6xrzPvmZf1N+c1jUIGQA6nG5Ebfm9RGKw3VYrQ72 K/h/SxR+U4k6bmMbm6basuy+G5N12buIDTXgh9iUckfP/wRs3zANvRud7t/GsIk7KcjleK5Dq qCsaT9jtIutPYhLviDn/2gnmU+dAhzsRbc/GATh4C/Jy7HBRYGD5uvhYijbqFgxWkSSdbs9vz 78nYfD/C3NDEk+5AkU/7NieY+O0UE3+Ppd3utjlxNOlnm2vDCfObjpFSnsL9pUkMQ5FlyRu2k IiNVQeMdG4evNVjsTQ8QPa0hBSPl438aGvIKRKztzD4a1WOqpuNpwE9YlCJwiYgFFI2CGcs95 wMqD3v/PjopJpujCR3jIjBIYBodhRrqNdEsSWhC/DRFs55K0G0dLdI68p/qsIxdy7ZBQRcroK lQDucMCY+/nYvV8oT2greXczbfLmrJRqnZDwWon0qY+W+IyGVcMas9XbAtQ7xG/0pIkKHamYY hro8/WeEtR5BYPAuXdM+RPSlh9LzJHxFgh1RwQtw2GcOw8LWH1FVTMN8zBxdDnmmSRKnvZx3l i7ETHH05z0ffA34IyoPZrkb3lcD8= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Forgot an important setting I have during pg_restore: On Thu, 10 Apr 2025, Dimitrios Apostolou wrote: > max_wal_size=3D64GB > max_replication_slots =3D 0 > max_logical_replication_workers =3D 0 > max_wal_senders =3D 0 > wal_level =3D minimal > autovacuum =3D off checkpoint_completion_target =3D 0 so the checkpoint should finish ASAP and any delays are purely because of I/O limitations. And for the sake of completion: checkpoint_timeout =3D 600s Regards, Dimitris