Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading to v12 - Mailing list pgsql-general

From Brad White
Subject Re: Upgrading to v12
Date
Msg-id CAA_1=91QfQS0EGYUzpqz=KDRKUeU3vEzJWnrTmoJrgWEPQ82MA@mail.gmail.com
Whole thread Raw
In response to Re: Upgrading to v12  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Upgrading to v12  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Tom,
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?
Or can I skip that?

On Fri, Nov 11, 2022 at 4:27 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Nonetheless,
your path forward is clear: use pg_dump (or better pg_dumpall)
and then load the output into a freshly initdb'd v12 installation.
It'll be a bit slower than the pg_upgrade way, but it'll work.

                        regards, tom lane

pgsql-general by date:

Previous
From: Kirk Wolak
Date:
Subject: Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...
Next
From: Tom Lane
Date:
Subject: Re: Upgrading to v12