Re: Upgrading error

2022-10-24 Thread chris navarroza
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"

Re: Upgrading error

2022-10-24 Thread chris navarroza
Hi, Thanks for the reply! Sorry I missed that line, but now I'm having new error. [root@datamartds tmp]# sudo su postgres bash-4.4$ cd /tmp bash-4.4$ /usr/pgsql-14/bin/pg_upgrade --old-datadir=/home/dmartuser/pgdata/data/ --new-datadir=/home/dmartuser/pgsql/14/data/ --old-bindir=/usr/pgsql-12/bi

Re: Upgrading error

2022-10-23 Thread Tom Lane
chris navarroza 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_p

Re: Upgrading error

2022-10-21 Thread Tom Lane
chris navarroza writes: > bash-4.4$ /usr/pgsql-14/bin/pg_upgrade > --old-datadir=/home/dmartuser/pgdata/data/ > --new-datadir=/home/dmartuser/pgdata/data/ --old-bindir=/usr/pgsql-12/bin/ > --new-bindir=/usr/pgsql-14/bin/ --check --verbose > Running in verbose mode > Performing Consistency Checks >

Upgrading error

2022-10-21 Thread chris navarroza
Hi, I have a postgresql server version 12.9 and trying to upgrade it to 14.5. My OS is Centos 8 Stream and I already managed to install postgresql14.5 but when I'm trying to upgrade, I am encountering this error bash-4.4$ /usr/pgsql-14/bin/pg_upgrade --old-datadir=/home/dmartuser/pgdata/data/ --n