postgres not working with the Servoy 5.2.2 Instalations

Classic Servoy
1

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

2

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…

3

In /application_server/postgres_db/ folder i dont have the postgres_log.txt

Any idea about why this log is not there?

4

Hi,
I followed what is adviced at:
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

5

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 ?

6

I use the postgres Installer: postgresql-9.0.1-1-windows.exe
I choose this location durnig the instalation.

7

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.

8

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.

9

Finally i reached to install servoy 5.2.2 with an external instalation of postgres
Thanks a lot for the help