From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Jeremy Wilson <jwilson(at)clover(dot)co> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist" |
Date: | 2020-11-13 16:35:13 |
Message-ID: | 38423984-6dfd-b243-316c-6c8391d68959@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
>
> bash-4.4$ cat 13/data/log/postgresql-Fri.log
> 2020-11-13 11:29:44.744 EST [205647] 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:29:44.744 EST [205647] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
> 2020-11-13 11:29:44.748 EST [205649] LOG: database system was shut down at 2020-11-13 11:29:19 EST
> 2020-11-13 11:29:44.755 EST [205647] LOG: database system is ready to accept connections
> free(): invalid pointer
> 2020-11-13 11:29:45.771 EST [205647] LOG: received smart shutdown request
> 2020-11-13 11:30:05.292 EST [205647] LOG: server process (PID 205659) was terminated by signal 6: Aborted
> 2020-11-13 11:30:05.292 EST [205647] LOG: terminating any other active server processes
> 2020-11-13 11:30:05.295 EST [205647] LOG: abnormal database system shutdown
> 2020-11-13 11:30:05.306 EST [205647] LOG: database system is shut down
> 2020-11-13 11:30:06.136 EST [205704] 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:30:06.136 EST [205704] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
> 2020-11-13 11:30:06.141 EST [205706] LOG: database system was shut down at 2020-11-13 11:30:05 EST
> 2020-11-13 11:30:06.148 EST [205704] LOG: database system is ready to accept connections
> 2020-11-13 11:30:06.195 EST [205712] FATAL: database "template1" does not exist
> 2020-11-13 11:30:06.200 EST [205704] LOG: received fast shutdown request
> 2020-11-13 11:30:06.201 EST [205704] LOG: aborting any active transactions
> 2020-11-13 11:30:06.204 EST [205704] LOG: background worker "logical replication launcher" (PID 205711) exited with exit code 1
> 2020-11-13 11:30:06.204 EST [205707] LOG: shutting down
> 2020-11-13 11:30:06.219 EST [205704] LOG: database system is shut down
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Wilson | 2020-11-13 16:37:15 | Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist" |
Previous Message | Adrian Klaver | 2020-11-13 16:32:01 | Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist" |