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 1pXiMm-00065k-NF for pgsql-admin@arkaria.postgresql.org; Thu, 02 Mar 2023 12:49:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXiMl-0003aT-1W for pgsql-admin@arkaria.postgresql.org; Thu, 02 Mar 2023 12:48:59 +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 1pXiMk-0003Wd-Kw for pgsql-admin@lists.postgresql.org; Thu, 02 Mar 2023 12:48:58 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXiMi-00011A-Cg for pgsql-admin@lists.postgresql.org; Thu, 02 Mar 2023 12:48:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1677761334; i=shammat@gmx.net; bh=ns6PRKrSCbzyriKFeDv9rEN0CbII61FcQz7GDnJq09g=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=pbL+BAPiGUDvWq7+Udea90QZ3IJAGOs3JhaFgGI5nO1wHHy3mG8oLMSzBmrMXvtIB a5CGHN9QYKLLsBw8fwkCQlEDcyPfzSxW7G/rRP/tBR+vw2YLeXvvGqy0C5fAXCoLcK RnUKoBgFChRg4JJLhQ6PfZtG2wX6mGc4tavCrjnSSrso32Vqq0CxwxdRIOxpnao5mT JfmTc0pp8FIBCBfeoPqCYTvjqy8zGUSmXqK9+3uNsrMcwcC1hRKYYjSJNX/jdSb3xg KLTx055HS/1l2JTLs7RGWpyKHWkujHL5KY8Zx3BF/Nzfd9J+TXD4l3NafUCPZy9eYI M+0yQUHJDiocA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.19] ([185.40.248.10]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1M2f5Z-1pbpdJ0w0d-004Bfx for ; Thu, 02 Mar 2023 13:48:54 +0100 Subject: Re: psql terminates on first error To: pgsql-admin@lists.postgresql.org References: <572addf0-5116-cec0-77fb-9a0ba0161240@jakobs.com> <453307953.83682.1677760371729@office.mailbox.org> From: Thomas Kellerer Message-ID: <1b41a19f-5672-e185-f3ec-df96c6dcbae7@gmx.net> Date: Thu, 2 Mar 2023 13:48:53 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:/hbUoGH4w8hPdCGWgObsPspZkUdGitJaeJYJ75dApkQeqlWX06O JCKcQxyvTWXefLNDcTFx+Uu1AHgwYHFd8MbDyTLnT/DrWXRrI98Q2JlLolm9xZx4+0gMHDW pkJoifW9+CEjX0xI/TwHJHc9Ptl6WbgXji2vOpNHYqMzJYAH260zy8MZZm755vt1GzVfTeC 2vT1oei9O7hCsMEWUn05Q== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:+Tc5oeO31VA=;YxJogPZnqj7qmvQF7XVX70fhwr8 /n3RzkNUGk7XrBnWl59wxDLrvjIn6LOzhDKaDjEydH1s5MBnoBZ7zA6vLNinZ30A71COuF/hJ xH+tvlQDQllLtyTcA6k8sOVEdZHE1+wcjmpvX4PKKXGVrlQc428wteoqHHSFc14aV7IXtxGZR BuT8NggRKNDxuOwJuDK2Ae8eUAvwsyw1BE3J0s4ROopYOSOWd984QVN0WHLiOamBpa6JHb0L9 YeStuqsQzB9srMRob13XE3lsOx5iYPotUHTzEtkH9SV1ZBFSFl0+BGccBRFPAg21BQ6l/3QmW QZ68t4GYFKC1nyvxbDMBq7REbjm2M7/uOCOrwo6/jJGcaDzwaIE7aCg8EreTeeQCf6c4JGhGN O/wjuG0Pb1KGpJUIODFVc+AFU3A2VymDeQUuKxWTTyd3oME2VFqzW/ZWiY3GD/VhPVRxfzMht UpXgZU/98Fq+TkrwkD4m/NZHiOGbmVBuMxUHdNuoCYKOc+TFhoeX7jGuvmmtqdKgLlHX46pOE J9xQCkKREtBBi++P7GE/rXcPvCyOH6afEs7MZ/nBQFCxn4M13NNfAI3gGs+GqRIZk2f0RE/NT dLzp+tzaU1Cq+pO05SlaZO3W2EcJ33Yl3bsACftYztbTtCR+ZXjy8c8VENUHlfd8cPHbddw6c pQ1wZt7ct6GgdJ9/V1xxbiiHlqQbfmWHsVtQxKWUAOLE10NNXQdCk4uuzI7yYJwzEz26XugxP fIR9AjQi/wsf4Y+rCXXtwrF2XBv5hRlOLDG665eitt5dwPIE+8p5vmA56Qwund3gQlfy+T94f 7GYbOJltdzGZVByQRZ+g2M/uTLRweKP9DDFvis6Gcg+nBXh2lj6ytgWP7bID1JJvJdBb1nJ7s j6KmNh0EK3ydGnBDBC7L1M/BNzGPPo9z1uFhoBjVt9oCbAK9mif7/r2N4N7HpocJeF/7F2saf mJ/2Elz+dYOE3Ae6sTQloIbp1yc= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Holger Jakobs schrieb am 02.03.2023 um 13:44: >>> Only when using an option -c "\set ON_ERROR_STOP false" (plus -f - of >>> course to continue reading) psql continued after first error. >> Do you use PowerShell and pipe pg_dumpall into psql?=C2=A0 The first th= ing that >> comes to my mind when reading Postgres+Windows is that PowerShell up to >> version 5.1 converts stdout to UTF-16LE.=C2=A0 This already tripped me = up in >> past with pg_dump and psql. > No, it was in cmd.exe or in bash I find using pipes with the Postgres command line tools on Windows unrelia= ble in general (including cmd.exe). So if you did use redirection/pips, try wi= thout.