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 1tvCRX-001uDv-0S for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 09:44: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 1tvCRV-000opW-94 for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 09:44:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuizn-00APN0-Qv for pgsql-general@lists.postgresql.org; Wed, 19 Mar 2025 02:17:27 +0000 Received: from [2001:bc8:1203:362::1] (helo=ns117.e-blokos.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tuizk-003cAD-2a for pgsql-general@lists.postgresql.org; Wed, 19 Mar 2025 02:17:26 +0000 Received: from [127.0.0.1] (ip6-localhost [127.0.0.1]) by mail.e-blokos.com (8.18.1/8.18.1) with ESMTP id 52J2HM0r015309 for ; Wed, 19 Mar 2025 02:17:23 GMT Content-Type: multipart/alternative; boundary="------------3azq7cLbxn3yU4BOMWVQkul0" Message-ID: <7248b50a-cf98-4169-a02d-f9a8f5e196ef@e-blokos.com> Date: Tue, 18 Mar 2025 19:17:22 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Cannot pg_dump_all anymore... Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <92435272-360f-48fa-8ca0-a4ea89359c80@e-blokos.com> From: E-BLOKOS In-Reply-To: X-Host-Lookup-Failed: Reverse DNS lookup failed for 2001:bc8:1203:362::1 (failed) 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. --------------3azq7cLbxn3yU4BOMWVQkul0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 3/18/2025 3:59 AM, Ron Johnson wrote: > On Tue, Mar 18, 2025 at 5:14 AM E-BLOKOS wrote: > > I got this error: > > pg_dump: error: query returned 0 rows instead of one: EXECUTE > dumpBaseType('794978') > > any clue to solve it? > > > PG version? > PG 17.4 > Whole command line, including all error messages? > > setpriv su - postgres -c "pg_dumpall --no-comments -h /run/postgresql -p 5432 > out.sql" -- E-BLOKOS --------------3azq7cLbxn3yU4BOMWVQkul0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


On 3/18/2025 3:59 AM, Ron Johnson wrote:
On Tue, Mar 18, 2025 at 5:14 AM E-BLOKOS <infos@e-blokos.com> wrote:
I got this error:

pg_dump: error: query returned 0 rows instead of one: EXECUTE
dumpBaseType('794978')

any clue to solve it?

PG version?

PG 17.4
Whole command line, including all error messages?


setpriv su - postgres -c "pg_dumpall --no-comments -h /run/postgresql -p 5432 > out.sql" 
-- 
E-BLOKOS
--------------3azq7cLbxn3yU4BOMWVQkul0--