Our databases are too big to live in /var/lib/pgsql, so we have them on a separate disk mounted in /mnt/postgres Su postgres # Exit MC first, or it hangs! There were just a few details I needed to do differently.įailed to link /usr/bin/psql -> /etc/alternatives/pgsql-psql: /usr/bin/psql exists and it is not a symlinkįailed to link /usr/bin/clusterdb -> /etc/alternatives/pgsql-clusterdb: /usr/bin/clusterdb exists and it is not a symlink The instructions in " CentOS: Upgrade PostgreSQL from 9.2 to 9.6" were very helpful.
So the better long-term solution seemed to be to upgrade PostgreSQL on CentOS. Pg_restore: unsupported version (1.13) in file header pg_restore 9.2 cannot restore backups which were made by 9.6, giving this cryptic error: But the machine doing nightly backups had Debian 9, and PostgreSQL 9.6.10. Our CentOS 7.5 machine had PostgreSQL version 9.2.24.
0 kommentar(er)
