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.96) (envelope-from ) id 1w1k7E-000ZD8-1I for pgsql-hackers@arkaria.postgresql.org; Sun, 15 Mar 2026 11:58:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w1k7D-004HjP-01 for pgsql-hackers@arkaria.postgresql.org; Sun, 15 Mar 2026 11:58:39 +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.96) (envelope-from ) id 1w1k7C-004HjH-1W for pgsql-hackers@lists.postgresql.org; Sun, 15 Mar 2026 11:58:39 +0000 Received: from mail-qt1-x82b.google.com ([2607:f8b0:4864:20::82b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w1k78-00000000Euy-37ab for pgsql-hackers@postgresql.org; Sun, 15 Mar 2026 11:58:37 +0000 Received: by mail-qt1-x82b.google.com with SMTP id d75a77b69052e-5062fc5d86aso34076741cf.1 for ; Sun, 15 Mar 2026 04:58:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1773575913; x=1774180713; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=Vyjh2gQljutkNZNIXf4gB9t4tzcb3ZTTOre/+G5oALc=; b=0QHfeL2dPLAlxjY39Pc5T3wZ1HjYgR9zF5VJNY94Uu/jMltxfCIwq46OIWCz6BzVal 7Nyrdpb3vZSqmU7iPt0bQkl7O42wxjqkiPjL01IcbnCA1QekEVxvRpSbM7ES/H5o3EXT 6IyE5ucwBPQ83fyoAlT1qDlemEt3cDRwdFbnCPbIpXDfRQ46dnx7kkHpWw7CzNHoG/U2 3VQ5mzD6tqCNy5H/Mbyk5meuvmbuC4loPi6Dlk9DEdHEcOf9bf9qjhK1NQw/kRty8oyH apUPb6am1RmbcYSUKGHDZGlzZJxr2EzouXs3iAfYDNOxmZbl1UKswWYYKMua0WjKXAY8 QtZA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773575913; x=1774180713; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:to:subject:user-agent:mime-version:date:message-id :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Vyjh2gQljutkNZNIXf4gB9t4tzcb3ZTTOre/+G5oALc=; b=AadBnN7PfcCjx8vA5+/HGococ+CE4wZrGRHayZwWErCvYRltp5JgFjwKhl0RsOPeez mmy+ST0WPblYlwW+an1/2HTRZC2kRMssp8WQOuwlmb1bYJS4W2oQoGzgYpOV5k6OPY2l qEh9OsMsywwtnr4dUGQBiAukJboly98vqFrFwkZLXdywXspyOljEUY3X5ZKH5x5Co3gF XtEeZbt0GdRwDRxn1jnJn9exP7A8xJJIf4eJ7Y1Dg/EIvPyGcEFUMkD3CMAP2tDFkZff E50njsnJdAaK3PuEaVSFOnHotMReKrN+Jaq6sJ9bKMARNw01TeAP4X6uEI/eUBe8Z+sl O0bQ== X-Forwarded-Encrypted: i=1; AJvYcCXjbj7rjIGSMIZixHojQz+bKcZR09FrxHoThnp2uPjkCFtHDf6hvku0Hd+JhyjtV1wZCxwzCTX90dUosQRw@postgresql.org X-Gm-Message-State: AOJu0YzoXLnH4n+B4AaOVxEpdytKrruhfwYIHAxMnJsUAVymYOoxWUSY OaHALVB5BI7PxjF7uQVao3Kf+V4xpf2WJ6Bhqg7GhUOM73raoKEbKGa6gWd/iza6DUo= X-Gm-Gg: ATEYQzxr6MuYZYxQIm6vVMmAIJccfHnPSr7DyJfwe3/+p94ofZ6GdOk43yVJrG6iteK lhIIcPo7hlpkx6vUOzd2zfolqFP3JmyAI9JYekrVTAwf1PnVRhv7acVKc3zaf1RayuE/ho9Rm8a WjfSA5LWf4nmwFXoTFZAexofXsEihNTDOEufJTcfPZBLJrJpBDK+bR3VVHxJEiRK8hOICAiUem8 wHK7a2qmNig146ppb/ifbMIvTX/8RPXTg+ZStIszipX/UapIPlggijID9aqHYHZkkV9Em8fpBIN 1ncnWQjbNVhWumpWMxAdoqHc3n9gAs0X4yg63Ug4pxYCSa/6ErOujeg9PS6bXqEb9GH+7ZVOzG5 jAEFbyhXd5M8zciPfbXa+zVKPlb0aY2UUHLl7c0nL0zEZpn1/SlQoeU0QH0og3T1sTjlM4R/RS3 0lnRQenEUaisnKUVUc4zUeNtwaJrMwIw== X-Received: by 2002:a05:622a:1986:b0:509:1d47:e795 with SMTP id d75a77b69052e-50957df1533mr123940441cf.44.1773575913145; Sun, 15 Mar 2026 04:58:33 -0700 (PDT) Received: from ?IPV6:2605:a601:a6b0:500::1cb? ([2605:a601:a6b0:500::1cb]) by smtp.googlemail.com with ESMTPSA id d75a77b69052e-5093a0e9658sm117767721cf.21.2026.03.15.04.58.32 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 15 Mar 2026 04:58:32 -0700 (PDT) Message-ID: Date: Sun, 15 Mar 2026 07:58:31 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: bug: pg_dumpall with --data-only and --clean options is giving an error after some dump To: Mahendra Singh Thalor , PostgreSQL-development References: From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAlwQTAQgAQQIbAwIX gAIZAQULCQgHAwUVCgkICwUWAgMBAAIeBRYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNGd BQkdEO8nAAoJEJn6f8tZ/DuBq74H/jkTR4Zi3stbw+xC7v2u3QozssK7MYPL2AsVfh7OealS h182fiWXpfvmmAB7WUHbhk9GC2RAOnHI/2d2jgKaMLAHsGYOT0YopTVIwRY43fCw/mK67yxc wmDcX+zyKfLaivNbf5A7QPLNwda98bEAMSJ8Sn652Uc6cA8t3uKGsVzbRBQOoYzjgvBCfSrE 9ql3PDNg0l4BfAqabd2f70ZUm9VAMEPrgv/v2xI7M2XiL4g5BVmqLCOwxLM8RMCotCuoweUr VO43DeBCIDwLxotMJKvGWDjBzQYlU1NPUAtNcz/gN9ITUe1VUGjyvGj4u1lxBOcQQUw7l1+T 5moZ4iZxXzvOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oKWaqf+wmW4tpDe/VV cxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7llV0xSSoFiieQBsr GvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8BoVrRFcdzlIY/NFN hFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C4R+M6w7o2PLGOjdZ +kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaYL++LAEOqrlvm2Tvq QqZRtnEAEQEAAcLAfAQYAQgAJgIbDBYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNI2BQkd EODdAAoJEJn6f8tZ/DuBfw0IAKTsfD40teP/pp+bsLLMSxPXUYrrprTj7WFB5v61p6dkpSr/ qXmMlyahdxQFaPmfVgVirB1Vk/kHiWNnnGjfUV9nB2Zg9LI0Xb9/ts3LsUiRWXzG3tkMY6XL vsVOxW4XFRND9l2q+WW93aZ1DZl+fqWfYgMvsusFRhmGFOKTRfKPta2Pkv+AhA24N4+PrR5p bU4k2MO8PAGiK8eaYKGFG1bHKuAvoDoF7WXJ3FHxuWqLnKEt4dfOLm5pAe3zq1Lt6q8azT9i QWGpSAK5vQUWQHBHpiDjdPeqKZ6HiAXIIKfSmb+jrvXBqoP+D6/K7rUjG2aXiRtTIAXms9sm VRu7cmw= In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-03-14 Sa 3:18 PM, Mahendra Singh Thalor wrote: > Hi all, > > I was doing some tests with pg_dump, pg_dumpall and pg_restore tools. > With "pg_dumpall --data-only --clean", we are reporting an error after > dumping some data. Hmm, this looks like behaviour that goes a long way back. Should we backpatch this fix? cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com