# postgres not working with the Servoy 5.2.2 Instalations
**URL:** https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052
**Category:** Classic Servoy
**Created:** [October 18, 2010, 11:54am UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052 "2010-10-18T11:54:37Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@mo\_ca\_mo](https://forum.servoy.com/u/mo_ca_mo)
#### Post date: [October 18, 2010, 11:54am UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/1 "2010-10-18T11:54:37Z")
Hello,
I wanted to upgrade to 5.2.2 version. I downloaded the instalator and run it.
But when i opened the servoy developer, none sever DB was working.
I double click over: C:\program files\Servoy5.2.2\application\_server\postgres\_db\bin\psql.exe
and i get message that said that the application couldn’t be started because its configuration is incorrct. Re-instaling the application can solve the problem.
Anybody has any idea about that?
Any help will be appreciated
---
### Author:  [@ptalbot](https://forum.servoy.com/u/ptalbot)
#### Post date: [October 18, 2010, 6:49pm UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/2 "2010-10-18T18:49:08Z")
I ran into something that could be related on several standard install of 5.2.2 with PostgreSQL.
Looking into the postgres\_log.txt located in /application\_server/postgres\_db/ I could see this:
> FATAL: could not open folder « pg\_tblspc » : No such file or directory
I googled this and found out that I needed to create a “pg\_tblspc” in the /database/ folder.
Still not working, this time postgres was looking for a “pg\_twophase” directory.
So I created this one too in the /database/ folder
This time postgres started alright, but when I went to see the log again, it was filled with messages related to not being able to find
> /pg\_stat\_tmp/pgstat.stat
So I created this folder and empty file and now he is happy!
I have a vague idea this is somehow related to auto-vacuum. Can someone confirm?
I still have a few messages like these though:
> ATTENTION: utilisation non standard de \ dans une chaîne littérale au caractère 99
> ASTUCE : Utilisez la syntaxe de chaîne d’échappement pour les antislashs, c’est-à -dire E’\'.
Meaning:
> ATTENTION, non standard usage of \ in a literal string at char 99.
> HINT: Use the escape string syntax for antislashs, ie E’\'.
Whatever that means…
---
### Author:  [@mo\_ca\_mo](https://forum.servoy.com/u/mo_ca_mo)
#### Post date: [October 19, 2010, 11:48am UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/3 "2010-10-19T11:48:28Z")
In /application\_server/postgres\_db/ folder i dont have the postgres\_log.txt
Any idea about why this log is not there?
---
### Author:  [@mo\_ca\_mo](https://forum.servoy.com/u/mo_ca_mo)
#### Post date: [October 22, 2010, 11:56am UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/4 "2010-10-22T11:56:37Z")
Hi,
I followed what is adviced at:
[viewtopic.php?f=5&t=14613&p=80766&hilit=problem+starting+repository+servoy+5.2#p80766](http://www.servoy.com/forum/viewtopic.php?f=5&t=14613&p=80766&hilit=problem+starting+repository+servoy+5.2#p80766)
So I instaled Postgresql 9.0 in the folder: Program Files/Servoy/application\_server/postgres\_db
but servoy keep without connection to repository.
Then registered posgresql as a service. (we are working with windows xp) using command lines:
initdb -D “postgres\_db\data” -E “SQL\_ASCII” –no-locale
pg\_ctl register -N “PostgreSQL” -D “postgres\_db\data” -l “pgsql\data\pgsql.log”
Now i have repostitory in servoy (at least the contection to: bug\_db, example\_data, log\_server, servoy\_repository, etc. appear without the red cross) but keep with problems:
- when i click on the DB servers (bug\_db, example\_data, etc) there are not tables there.
- when i set a conection with a data base i use to my proyect Servoy lose the contecion with the other DB servers and the red crosses came back
Other doubt: where is saved the servoy\_repository files? Before they were in application\_server/database folder but
with the instalation of Servoy 5.2.2 I didnt found them.
Any help to fix this problem??
Thank you
---
### Author:  [@ROCLASI](https://forum.servoy.com/u/ROCLASI)
#### Post date: [October 22, 2010, 12:11pm UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/5 "2010-10-22T12:11:16Z")
> mo\_ca\_mo:
> So I instaled Postgresql 9.0 in the folder: Program Files/Servoy/application\_server/postgres\_db
Eh, how did you install PostgreSQL 9.0 there?
You used the EDB installer and then moved the directory over ? Or did you use another installer ?
---
### Author:  [@mo\_ca\_mo](https://forum.servoy.com/u/mo_ca_mo)
#### Post date: [October 22, 2010, 12:36pm UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/6 "2010-10-22T12:36:41Z")
I use the postgres Installer: postgresql-9.0.1-1-windows.exe
I choose this location durnig the instalation.
---
### Author:  [@ROCLASI](https://forum.servoy.com/u/ROCLASI)
#### Post date: [October 22, 2010, 12:46pm UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/7 "2010-10-22T12:46:33Z")
Okay, then the installer already registered the PostgreSQL instance as a service. Your data is located in Program Files/Servoy/application\_server/postgres\_db/ **data/**.
And you don’t need to use initdb because the installer already done that for you as well.
Of course this new database cluster doesn’t have the demo databases so that is why you have the red crosses. You need to create those databases (right-click on the connection \> Create Database) and then import the demo solution (this will create the tables for you).
Oh and the super-user is not DBA in this case. It’s ‘postgres’ with the password you filled in the installer. So you need to edit your connection settings to use this database user.
Also if you did install PostgreSQL while Servoy (and thus it’s PostgreSQL instance) was running then your PostgreSQL 9.0 will be using port 5433 instead of 5432. You need to change that also then in your connection settings.
Hope this helps.
---
### Author:  [@ROCLASI](https://forum.servoy.com/u/ROCLASI)
#### Post date: [October 22, 2010, 12:59pm UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/8 "2010-10-22T12:59:25Z")
Actually if you set the path in the installer for the binary did you perhaps also set the path for the database cluster ?
If not then it’s in the data directory of the postgres\_db directory, else it’s in the location you told it to be.
Hope this helps.
---
### Author:  [@mo\_ca\_mo](https://forum.servoy.com/u/mo_ca_mo)
#### Post date: [October 29, 2010, 11:34am UTC](https://forum.servoy.com/t/postgres-not-working-with-the-servoy-5-2-2-instalations/13052/9 "2010-10-29T11:34:52Z")
Finally i reached to install servoy 5.2.2 with an external instalation of postgres
Thanks a lot for the help