Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

I’m running CentOS 8 on an EC2 instance and attempting to upgrade a 9.5 database to 13 using pg_upgrade. Both are running on the same box and pass initial tests but it fails during the later part of the process. --- bash-4.4$ /usr/pgsql-13/bin/pg_upgrade --old-bindir /usr/pgsql-9.5/bin --new-

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 9:58 AM, Adrian Klaver wrote: > > To me it seems the initdb for the 13 instance did not complete successfully. > Have you tried clearing /var/lib/pgsql/13/data and doing the init over again? > If you do try it monitor the output carefully. here’s the complete process:

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 10:09 AM, Adrian Klaver wrote: > > In your previous post you had --socketdir=/var/run/postgresql/. Did you > change that or is it missing? Sorry, here it is with the socket directory specified. bash-4.4$ rm -r 13/data/* bash-4.4$ bash-4.4$ /usr/pgsql-13/bin/initdb -D /

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 10:23 AM, Tom Lane wrote: > > Unless ... could it be that there is another PG server active on the > machine, whose cluster lacks a "template1" database? Seems unlikely, > but you might try confirming with "ps auxww | grep post" or the like. This is a test environment s

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 10:46 AM, Tom Lane wrote: > > Hmph. We know that 9.5 -> 13 pg_upgrade works in simple scenarios, > because the buildfarm tests that every day. So there has to be > something out of the ordinary about your setup. Any unusual > extensions, pg_hba.conf configuration, etc?

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 11:06 AM, Adrian Klaver wrote: > > When you manually run the pg_upgrade pg_ctl script the server starts but you > cannot connect to any database in it correct? Yes. > What does pg_upgrade_server.log show when you do above? -

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 11:26 AM, Adrian Klaver wrote: > > What shows up in the log file in "log" directory when you try to connect to a > database? 2020-11-13 10:14:35.821 EST [204797] LOG: starting PostgreSQL 13.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 11:26 AM, Adrian Klaver wrote: > > What shows up in the log file in "log" directory when you try to connect to a > database? I did a completely fresh initdb to get clean logs: bash-4.4$ cat 13/data/log/postgresql-Fri.log 2020-11-13 11:29:44.744 EST [205647] LOG: start

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 11:35 AM, Adrian Klaver wrote: > > On 11/13/20 8:31 AM, Jeremy Wilson wrote: >>> On Nov 13, 2020, at 11:26 AM, Adrian Klaver >>> wrote: >>> >>> What shows up in the log file in "log" directory when you try to

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 11:39 AM, Adrian Klaver wrote: > > This does not show trying to connect to a database. It would help to list the > commands run and then the corresponding log portions. bash-4.4$ "/usr/pgsql-13/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql/13/data" -o "-

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 12:00 PM, Tom Lane wrote: > > Are you by any chance trying to preload any of the postgis-related > extensions? If so, try not doing that. Not sure what you mean by this - I’ve installed the postgis packages for 9.5 and 13 and the extensions are installed and working in

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 12:06 PM, Adrian Klaver wrote: > > Hmm. You can still connect if you use?: > > /usr/pgsql-13/bin/pg_ctl -D /var/lib/pgsql/13/data/ -l logfile start Same result. bash-4.4$ /usr/pgsql-13/bin/pg_ctl -D /var/lib/pgsql/13/data/ -l logfile start waiting for server to start..

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

> On Nov 13, 2020, at 1:10 PM, Magnus Hagander wrote: > > The problem is that postgis, through gdal, ended up being linked to two > different versions of proj at the same time. > > You can check it by doing: > ldd /usr/pgsql-13/lib/postgis_raster-3.so | grep proj > > If that shows up two di

pg_upgrade of 11 -> 13: free(): invalid pointer

I’m continuing my upgrade journey, this time from 11 to 13, and the process is dying in the copy phase, always on the same DB: — Performing Upgrade -- Analyzing all rows in the new cluster ok Freezing all rows in the new clusterok Dele

Re: pg_upgrade of 11 -> 13: free(): invalid pointer

> On Nov 17, 2020, at 12:18 PM, Adrian Klaver wrote: > > On 11/17/20 8:59 AM, Jeremy Wilson wrote: > > Was this after a clean install of the corrected RPM’s? Yes, this is a fresh install of CentOS 8 and installed using the updated repo and RPMs.