This is the log I got.
-----------------------------------------------------------------pg_upgrade run on Mon Oct 24 07:41:13 2022
-----------------------------------------------------------------
command: "/usr/pgsql-12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/home/dmartuser/pgdata/data" -o "-p 50432 -b -c config_file=/var/lib/pgsql/12/data/postgresql.conf -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/tmp'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....2022-10-23 23:41:13.458 GMT [107444] LOG: skipping missing configuration file "/home/dmartuser/pgdata/data/postgresql.auto.conf"
2022-10-24 07:41:13.459 PST [107444] LOG: starting PostgreSQL 12.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit
2022-10-24 07:41:13.460 PST [107444] LOG: listening on Unix socket "/tmp/.s.PGSQL.50432"
2022-10-24 07:41:13.486 PST [107444] LOG: redirecting log output to logging collector process
2022-10-24 07:41:13.486 PST [107444] HINT: Future log output will appear in directory "log".
stopped waiting
pg_ctl: could not start server
Examine the log output.
Chris Albert Navarroza
Information Technology Officer I
CTCO - ITDS - RDMD
Information Technology Officer I
CTCO - ITDS - RDMD
On Mon, Oct 24, 2022 at 8:12 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
chris navarroza <canavarroza.work@xxxxxxxxx> writes:
> could not connect to source postmaster started with the command:
> "/usr/pgsql-12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
> "/home/dmartuser/pgdata/data" -o "-p 50432 -b -c
> config_file=/var/lib/pgsql/12/data/postgresql.conf -c listen_addresses=''
> -c unix_socket_permissions=0700 -c unix_socket_directories='/tmp'" start
> Failure, exiting
Did you look into the postmaster log (pg_upgrade_server.log, here)
to see what it thought about the problem? I'm guessing there's
something that kept it from starting, but there's no evidence
offered here about what.
regards, tom lane
