On Thu, Nov 14, 2019 at 08:26:48AM +0100, Laurenz Albe wrote:
> If you have data corruption, you shouldn't use pg_upgrade to upgrade.
> pg_dumpall / psql is the way to go.
Please refer to this wiki page:
https://wiki.postgresql.org/wiki/Corruption
If you have a cluster in such a state, you have r
ailed: FATAL: root page 3 of index
> "pg_class_oid_index" has level 0, expected 1
>
>
> could not connect to old postmaster started with the command:
> "/postgresql94/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
> "/data/directory/postgresql&
=0700 -c
unix_socket_directories='/home/postgresql_user'" start
Failure, exiting
Again, I was trying to take the pg_dumpall of the same database
cluster(PostgreSQL v9.4) and it failed with error:
pg_dump: [archiver (db)] connection to database "template1" failed: FATAL:
root
