I am left with a broken postgresql since my upgrade to Fedora 24.
Starting the service retruns this error:
# /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
------------------------------------------
------------------------------------
# cat /var/lib/pgsql/upgrade_postgresql.log
-- connection to database failed: could not connect to server: No such
file or directory
Is the server running locally and accepting
connections on Unix domain socket "/home/postgres/.s.PGSQL.5432"?
could not connect to old postmaster started with the command:
"/usr/lib64/pgsql/postgresql-9.4/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/db/pgsql/data-old" -o "-p 5432 -b -c
listen_addresses='' -c unix_socket_permissions=0700 -c
unix_socket_directories='/home/postgres'" start
Failure, exiting
---------------------------------------------
What am I supposed to do now? It seems a trick would be to install
last version 9.4.8 alongside, then run both 9.4.8 and 9.5 with my data
for 9.4 and new empty data base for 9.5, then dump from older to new
one db. Is it correct? Anyway to make postgresql-setup works ?
Thank you for help
google.com/+arnaudgabourygabx
--
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
