The following bug has been logged on the website:
Bug reference: 13646
Logged by: Jeremy Whiting
Email address: jwhiting@redhat.com
PostgreSQL version: 9.4.4
Operating system: Fedora 22, Linux burtha-f22 4.1.6-200.fc22.x86_64
Description:
Hi,
I have been trying to upgrade a database created using 9.2.0. Using the
postgresql-setup version 9.4.4. This issue happens on two machines both
running Fedora 22.
After installing the "PostgreSQL Yum Repository" for Fedora 22 I followed
the instructions to start the database. This error message was displayed
when starting.
$ sudo service postgresql startRedirecting to /bin/systemctl start
postgresql.service
Job for postgresql.service failed. See "systemctl status postgresql.service"
and "journalctl -xe" for details.
Using journalctl -xe I found this message indicating an error.
Sep 28 09:10:11 burtha-f22 systemd[1]: Starting PostgreSQL database
server...
-- Subject: Unit postgresql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit postgresql.service has begun starting up.
Sep 28 09:10:11 burtha-f22 postgresql-check-db-dir[27169]: An old version of
the database format was found.
Sep 28 09:10:11 burtha-f22 postgresql-check-db-dir[27169]: Use
"postgresql-setup --upgrade" to upgrade to version 9.4.
Sep 28 09:10:11 burtha-f22 postgresql-check-db-dir[27169]: See
/usr/share/doc/postgresql/README.rpm-dist for more information.
Sep 28 09:10:11 burtha-f22 systemd[1]: postgresql.service: control process
exited, code=exited status=1
Sep 28 09:10:11 burtha-f22 systemd[1]: Failed to start PostgreSQL database
server.
Which says an old database was found. I followed the instructions to use
the tool postgresql-setup with the flag --upgrade to complete the upgrade.
But that did not work. I see this message.
$ postgresql-setup --upgrade
* Upgrading database.
ERROR: failed
* See /var/lib/pgsql/upgrade_postgresql.log for details.
Checking the file using cat I see this
$ cat /var/lib/pgsql/upgrade_postgresql.log
$
meaning it is empty. The file was opened to be written but nothing was
written to the file.
$ date
Mon 28 Sep 09:47:13 BST 2015
$ ls -l /var/lib/pgsql/upgrade_postgresql.log
-rw-------. 1 postgres postgres 0 Sep 28 09:30
/var/lib/pgsql/upgrade_postgresql.log
I was expecting to see some indication of the problem in
upgrade_postgresql.log
to help troubleshoot further.
Not finding any this report has been generated because other users may come
across the same issue.
