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

On 11/13/20 8:37 AM, Jeremy Wilson wrote:
>
>
>> On Nov 13, 2020, at 11:35 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>>
>> On 11/13/20 8:31 AM, Jeremy Wilson wrote:
>>>> On Nov 13, 2020, at 11:26 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> 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:
>>
>> Was the below from starting using the pg_upgrade version of pg_ctl start?
>
> No, strictly from running pg_upgrade.
>
> Here’s the additional logs from manually running it:
>
> 2020-11-13 11:36:35.976 EST [205733] LOG: starting PostgreSQL 13.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit
> 2020-11-13 11:36:35.976 EST [205733] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
> 2020-11-13 11:36:35.981 EST [205735] LOG: database system was shut down at 2020-11-13 11:30:06 EST
> 2020-11-13 11:36:35.989 EST [205733] LOG: database system is ready to accept connections
>

This does not show trying to connect to a database. It would help to
list the commands run and then the corresponding log portions.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com