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 1ozqHj-00037B-Qb for pgsql-general@arkaria.postgresql.org; Tue, 29 Nov 2022 02:23:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ozqHi-0003fB-Of for pgsql-general@arkaria.postgresql.org; Tue, 29 Nov 2022 02:23:46 +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 1ozqHg-0003f2-SD for pgsql-general@lists.postgresql.org; Tue, 29 Nov 2022 02:23:46 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ozqHc-00068a-2F for pgsql-general@lists.postgresql.org; Tue, 29 Nov 2022 02:23:42 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id A142B320090B; Mon, 28 Nov 2022 21:23:37 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Mon, 28 Nov 2022 21:23:37 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to; s=fm3; t=1669688617; x= 1669775017; bh=LHO6NAV8Y1nlO2kxN7JhohsqfdsxP/AmSfkbayUg+0Y=; b=4 fK9DyCPoah2IgzxwnyEO0xDxBkCyO/0QZYyE4kBWN0fYZ+S/L1vRGBOE0Rq5dDMm hPN6MX0Vaz8Nsd+uojqpZUCh16qEfLZX1/YGSubuxGWSLTEyOP23V1skI6lphTnz F9254C6gP1gPCNIDazar1KJyU/Q8YwCJOq+sY/7/NLehbJQuGTO3J+ITm8IInUh8 yDbE7GC4Kcd1yWjFW2ihiAhb5lBt91SN1Lu/pUWAyhanYcGliu1tPiLOJCLEutmZ HHlhtaCOUfCRHEHRf4OPrEW1hNzF70GvW8ZZyfEy5wNE0U4LiTSWKhccKcgw4KlV e15E0nfQ1xcyCwfFm8/Mw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1669688617; x= 1669775017; bh=LHO6NAV8Y1nlO2kxN7JhohsqfdsxP/AmSfkbayUg+0Y=; b=q jRm5ZtmIoM4JATWqplmdPz99iiyb2swNxcGBxZnSpSmmmw3ZtmwcW0UqUzkzcouc CNWQgJyZ671nKehkuRpAQKyWTVD/30KVdLFKIX5x0OEZXdDjQy9mfORXc/0o7Yhm C6VXfui+twXVxbSIx93kiKC14eY1i0RIQuDr8AoPmrIAVw1BfgcBbkSEIBcKpSw5 Wok9RBEkEsS4yu0DQPmfhSrNg0cJ5iguvmWD3/zQ/Qqxi6E5LTG9oITCndNlXMkq /aVZeElbrlweBLdwZ4kIeXyYNfoJn+hiNw0PpEH7HpfA05HEJSJcBLRS8xFyGJMY NHtl8IIFeCBKM683KONkQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvgedrjeefgdegjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfevfhfhjggtgfesthejredttdefjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeduieehueevffejteefffetkeetfeettdegheffvdfh tdetgfeiffejheekjeekgeenucffohhmrghinhepshhtrggtkhhovhgvrhhflhhofidrtg homhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegr ughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 28 Nov 2022 21:23:35 -0500 (EST) Message-ID: Date: Mon, 28 Nov 2022 18:23:34 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Subject: Re: Upgrading to v12 To: Tom Lane , Brad White Cc: pgsql-general@lists.postgresql.org References: <9aa1a829-3367-74cf-1630-a91a4d67d41d@aklaver.com> <128408.1668205654@sss.pgh.pa.us> <780241.1669683739@sss.pgh.pa.us> Content-Language: en-US From: Adrian Klaver In-Reply-To: <780241.1669683739@sss.pgh.pa.us> 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 11/28/22 17:02, Tom Lane wrote: > Brad White writes: >> I tried to run initdb after re-installing pg 12 >> using postgresql-12.10-2-windows-x64.exe. >> But the runas I'm using to execute it as pguser seems to be swallowing all >> the output, so I can't see any errors. >> I was able to run pg_checksums and get those enabled. >> Is there anything else I want from initdb? > > If you can connect to the new installation, then you're done with > that part, and can get on with the dump-and-restore part. Yeah this is coming from this SO question: https://stackoverflow.com/questions/74607304/what-results-should-i-see-from-running-initdb#comment131694419_74607304 Brad was double clutching on the initdb. > > regards, tom lane > > -- Adrian Klaver adrian.klaver@aklaver.com