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 1rke6v-00EGYW-8g for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Mar 2024 05:58:37 +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 1rke6s-00FOJI-VE for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Mar 2024 05:58:35 +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 1rke6s-00FOJ9-IT for pgsql-bugs@lists.postgresql.org; Thu, 14 Mar 2024 05:58:35 +0000 Received: from mail-wr1-x42e.google.com ([2a00:1450:4864:20::42e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rke6p-004PMk-4R for pgsql-bugs@lists.postgresql.org; Thu, 14 Mar 2024 05:58:33 +0000 Received: by mail-wr1-x42e.google.com with SMTP id ffacd0b85a97d-33e76d653b5so499027f8f.3 for ; Wed, 13 Mar 2024 22:58:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1710395909; x=1711000709; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=jmWE1X3//CDt8O/iWj90hIzFS60bcJldGjd8V76/7cU=; b=fLMMBppT++G0aUapuCKLA6bXjFXjzqXuAHhHsjdFGAdnLr2La0aYMfE6OXRqajh865 pQ7lXr40b/igQ/J2AjjBb3xhGFWUoM3ie6wiYXTJSpXznVZ7Oph2Gc45oU0CCGSDZ9ak Ttjnh+7zdxEMH9JfCPzkZSnJfAwWEtm2/XVORbgfBRz5lxT57T7vriwH7VV9CHbGgF/S RG2LVq8aHpa6Ceng5hGk5dj50xydWl5T9uErnrk8mFxC5wj5fkJtjizZeFCBPjuwKX4t c0VPe+i3yL9lQ7ptMUHsiEeKYG7UzCIcirhlZjltSBR9HF1HlmBcVdiyUVIzLCbd8Nfz zE2w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1710395909; x=1711000709; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=jmWE1X3//CDt8O/iWj90hIzFS60bcJldGjd8V76/7cU=; b=rvLsR9O2pg7rYRIwKAdb4hl26UFx6l3lxGE2cYdEWiKl5XP68uXlXlw7KCg6UsPyjK 5sugfXBKsYepSCvNn9V72nctqw6wmXEKuKK21Jj753IDe5bviPDDuY/tk8p4CsF1k4Ww 36Cq1S+PTF+69+F32yamHRtl4cUIDLgiSiM/4uc31QyCJOMnpMYMoLEBfGRVoJLFydic q8xcK81a4KJAyD2zLUoXm0VVOv1I4ZKc2i3Swdw3+RKSEguCB9l2n7FUgbtpN8WSjSxh j7U1HRVPsFyzryfl6SjxGakndYuUDIBZUXWoe8PJUMfJsQJCX2u4uJrDHlmCSgcj0yeJ F2PQ== X-Forwarded-Encrypted: i=1; AJvYcCV2hgz1ULZzp/BHZ+nEIFQfQ6MtnrZDNJ9sN2jjmhsZEnWbGKQXISsBL7DmmxRxUcHNVqkI8iJ7Ezv1lrdnPCYYEtL91sL8W3elmlDwiAiF X-Gm-Message-State: AOJu0YzJi0Nd37YiVMeG2KeXgt3ghQ7w7CdcLvmOsLa73YdCMODcU7K8 pGup86wnzCJAlyeX3WxoxHCGoOLIbeJ0D4OXIOY9f8iJ92KqWTMo6a//GQeYc2I= X-Google-Smtp-Source: AGHT+IHr1UuD1lvf8nuwt2c5/NyPHcxxLr41551938V6TsMkhPbay/87JURBfs+8y4UvibVA1Mw46w== X-Received: by 2002:a05:6000:d49:b0:33d:6fd8:90d3 with SMTP id du9-20020a0560000d4900b0033d6fd890d3mr488411wrb.4.1710395909270; Wed, 13 Mar 2024 22:58:29 -0700 (PDT) Received: from localhost.localdomain (lfbn-idf3-1-705-160.w86-252.abo.wanadoo.fr. [86.252.41.160]) by smtp.gmail.com with ESMTPSA id f13-20020a05600c154d00b00413f25d9104sm867836wmg.40.2024.03.13.22.58.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 13 Mar 2024 22:58:29 -0700 (PDT) Message-ID: Subject: Re: BUG #18392: Can't restore database (using pg_restore) after latest Feb 8 update From: Laurenz Albe To: carl@msupply.foundation, pgsql-bugs@lists.postgresql.org Date: Thu, 14 Mar 2024 06:58:28 +0100 In-Reply-To: <18392-142078457489d3a5@postgresql.org> References: <18392-142078457489d3a5@postgresql.org> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2024-03-14 at 03:06 +0000, PG Bug reporting form wrote: > PostgreSQL version: 14.11 > Operating system: MacOS >=20 > We regularly save snapshots of our app state using pg_dump and restore th= em > with pg_restore. However, after the latest update (12.18 etc), we can no > longer use pg_restore to restore the database -- it just throws a bunch = of > errors, mainly to do with tables not existing (that should exist). Please don't keep us guessing and show us the errors. The first couple of error messages will be enough, the remainder is often a consequence of thos= e. Yours, Laurenz Albe