Page 1 of 1

Problem connecting databases - SOLVED

PostPosted: Mon Jul 08, 2019 11:23 am
by cp
Update:
2019-07-08 16:06:21.961 CEST [1223] FATAL: database files are incompatible with server
2019-07-08 16:06:21.961 CEST [1223] DETAIL: The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.7.

Did we get a new version of psql?
Anyhow copying the RC2 postgresSql with the final version og 2019 06 made things work.

--
Since I'm not the most database savvy I truly hope someone can point me in the right direction.

So, I did a clean update to SVY 2019 06 final, and installed the SVY version of Postgressql. I copied my old servoy.properties file to point to the right data folder.

Subsequently I see the databases in SVY but they are not connected. I made sure that the DB service is started and that a valid role is used - still I cannot see my old database/tables - not even in PGAdmin.

Any ideas would be highly appreciated?

/CP
Mac OSX

2019-07-08 02:59:35,130 ERROR [Worker-19: Loading servers/tables needed by current solution] persistence.Server - Final get connection failure for server repository_server in 1 times [ ]

Re: Problem connecting databases - SOLVED

PostPosted: Tue Jul 09, 2019 4:41 pm
by jcompagner
what i don't get it seems to have a "database" directory that is made by an old postgresql

in 2019.06 (from the first RC on) we ship a postgresql that is 10.7 version..
So i don't get how you get there old database files (if you do a new install)

Re: Problem connecting databases - SOLVED

PostPosted: Wed Dec 18, 2019 3:56 pm
by c85700
I think problem in old version