Font size:

Running ER/Box with PostgreSQL

Using ER/Box with PostgreSQL as the target database does not differ too much from running it with Derby.

Client

When the application server is started and configured to connect to a PostgreSQL instance usually nothing has to be done on the client side; the new target database is automatically detected.

To configure the client connection manually please click on the Server line in the login dialog:

The connection parameters can be adjusted in the following screen:

Client Connection Screen Filled

If a connection to the application server or the database cannot be established the dialog may hang and it might be necessary to kill the client application from the Task-Manager (Windows).

Switching the database

If you would like to switch the target database for the client without a running application server, both, the currently configured database and the new target database, have to be online and reachable. Otherwise the client startup will hang indefinitely!

Server

After the server is configured to use PostgreSQL (see here) two steps are necessary to start ER/Box:

Start PostgreSQL
Start ER/Box
- Windows: Doubleclick on the batchfile {COMPIERE_HOME}\utils\RUN_Start.bat