Re: postgresql-setup upgrade returns error

[stan]

On Thu, 7 Jul 2016 10:11:52 +0200
arnaud gaboury  wrote:

> I am left with a broken postgresql since my upgrade to Fedora 24.

[snip]

> 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 ?

A search turned up this.  Does it help?
http://stackoverflow.com/questions/24379373/how-to-upgrade-postgresql-from-version-9-4-to-version-9-5-without-losing-data
--
users mailing list
users@lists.fedoraproject.org
To unsubscribe or change subscription options:
https://lists.fedoraproject.org/admin/lists/users@lists.fedoraproject.org
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

postgresql-setup upgrade returns error

[arnaud gaboury]

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@lists.fedoraproject.org
To unsubscribe or change subscription options:
https://lists.fedoraproject.org/admin/lists/users@lists.fedoraproject.org
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