On Friday, July 8, 2016 2:10:43 PM CDT arnaud gaboury wrote: > My upgrade from Fedora 23 to 24 left me with a broken postgresql. > > > # /usr/libexec/postgresql-ctl start -D /db/pgsql/data -s -w -t 270 > FATAL: 22023: database files are incompatible with server > DETAIL: The data directory was initialized by PostgreSQL version 9.4, > which is not compatible with this version 9.5.3. > LOCATION: ValidatePgVersion, miscinit.c:1364 > pg_ctl: could not start server > Examine the log output. > > <Note: my data are in /db/pgsql/data> > > --------------------------------------------- > # postgresql-setup --upgrade > > * Upgrading database. > ERROR: pg_upgrade tool failed > ERROR: Upgrade failed. > * See /var/lib/pgsql/upgrade_postgresql.log for detai > ------------------------------------------ > > It seems I must install 9.4.8 alongside my current 9.5.3, then dump a > backup from 9.4.8 and restore with 9.5.3. Is it possible to install > 9.4.8 ? I found 9.4.8 .rpm packages for Fedora 23. How can I install > them without touching anything to 9.5? > > Is there any other solution to solve this initialisation issue? > > Thank you for help in solving this postgresql issue. I've found that in order for postgresql-upgrade to work, I've needed to remove my specific postgresql.conf customizations such as: ssl = on krb_server_keyfile = 'postgres.keytab' shared_preload_libraries = 'pg_journal' And change the local entry for the postgres user in pg_hba.conf to trust: TYPE DATABASE USER ADDRESS METHOD local all postgres trust Then run $ postgresql-setup --upgrade After the upgrade, I replace the configuration customizations and $ systemctl restart postgresql.service -- Anthony - https://messinet.com/ - https://messinet.com/~amessina/gallery F9B6 560E 68EA 037D 8C3D D1C9 FF31 3BDB D9D8 99B6
Attachment:
signature.asc
Description: This is a digitally signed message part.
-- users mailing list users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe or change subscription options: https://lists.fedoraproject.org/admin/lists/users@xxxxxxxxxxxxxxxxxxxxxxx Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
