Installing Servoy App Server: Catalog and Schema?

Classic Servoy
1

I am currently trying to install my first Servoy application server, closely following the docs from this source:
https://wiki.servoy.com/display/Serv7/Installing+the+Application+Server

I first installed Postgres 7.4.11 and the latest Java 8u121 on the target server.
Then I downloaded the Servoy App Server installation package and started it.

I choosed the third option stating that I already installed postgres separately.

Now I got stuck on the two fields Catalog and Schema in the window below.
What am I supposed to put in there?
[attachment=0]servoy_catalog_schema.png[/attachment]

servoy_catalog_schema.png
servoy_catalog_schema.png755×594 16.5 KB

2

Hi Bernd,

Bernd.N:
I first installed Postgres 7.4.11…

:shock:

Okay, now you’re scaring me.
PostgreSQL 7.4.11 was released on January 9, 2006. I assume you are talking about PostgreSQL 9.4.11. ;)

Bernd.N:
Now I got stuck on the two fields Catalog and Schema in the window below.
What am I supposed to put in there?

You can put in in both fields if you didn’t setup your own schema.
Also your server URL should include the database name, i.e.; jdbc:postgresql://localhost:5432/myDatabase.

Hope this helps.

3

Yes, you are right, it is certainly 9.4.11, I mixed it up with Servoy :?

4

Oh wait, you are talking about the installer, not the servoy-admin pages (reading is hard!) :oops:
You can simply leave them empty and no need to add the database name/

5

Yes that is also my experience.
When adding a database name at the end of the URL, like bob in our case, the servoy.properties file will contain
server.0.URL=jdbc:postgresql://localhost:5432/bob/servoy_repository
instead of the proper
server.0.URL=jdbc:postgresql://localhost:5432/servoy_repository

Then the proper creation of the repository will certainly fail.