PostgreSQL connection not working

Discussions about product bugs & problems!
Note: This is no replacement for the Official ETM Support!
2 posts • Page 1 of 1
erik.schwing
Posts:16
Joined: Tue Feb 12, 2019 6:59 am

PostgreSQL connection not working

Post by erik.schwing »

Hi,

I am trying to setup the NGA using the postgreSQL backend as described in the help.
At some step a folder structure needs to be made but it seems like an image is missing from the online help at this section.

I have tried setting up the db,alarms,events,backups folder in the db/NGA/postgreSQLBackend folder. This was my best guess where they should go.
Then i ran the batch file to create a DB (after changing the config). The nga manager returns the error that no active database could be found constantly. I have setup the correct 'localhost', port, username, and password in OA and PGAdmin.

Could a wrong installation (folder) of postgreSQL be the problem?
A faulty config somewhere?

Best regards,
Erik

erik.schwing
Posts:16
Joined: Tue Feb 12, 2019 6:59 am

Re: PostgreSQL connection not working

Post by erik.schwing »

I Managed to get it working after a number of reinstallations of PostgreSQL database.
By default the installer will choose [Default locale] when creating the database, which for me was dutch_netherlands.12521.
With this locale the database connection does not work!

During the last reinstall i set the locale the english_Unitedstates and did the exact same steps to create the DB and it works.

2 posts • Page 1 of 1