On 11/13/20 8:19 AM, Jeremy Wilson wrote:
>
>
>> On Nov 13, 2020, at 11:06 AM, Adrian Klaver <adrian.klaver@aklaver.com> 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?
>
> -----------------------------------------------------------------
> pg_upgrade run on Fri Nov 13 10:11:45 2020
> -----------------------------------------------------------------
>
>
> command: "/usr/pgsql-13/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql/13/data" -o "-p 5432 -b -c
synchronous_commit=off-c fsync=off -c full_page_writes=off -c vacuum_defer_cleanup_age=0 -c listen_addresses='' -c
unix_socket_permissions=0700-c unix_socket_directories='/var/run/postgresql'" start >> "pg_upgrade_server.log" 2>&1
> waiting for server to start....2020-11-13 10:12:15.902 EST [204782] LOG: redirecting log output to logging collector
process
> 2020-11-13 10:12:15.902 EST [204782] HINT: Future log output will appear in directory "log".
> done
> server started
What shows up in the log file in "log" directory when you try to connect
to a database?
>
>
> command: "/usr/pgsql-13/bin/pg_ctl" -w -D "/var/lib/pgsql/13/data" -o "" -m fast stop >> "pg_upgrade_server.log"
2>&1
> waiting for server to shut down.... done
> server stopped
>
--
Adrian Klaver
adrian.klaver@aklaver.com