postgresql database inaccessible

[Daniel Addo]

I have this issue on my wily how do I resolve it?

postgresql database inaccessible

[Matthew Muskaloon]

Hi,

 

There are a few things here that could be the cause.

 

1. Postgres is not running

2. If Postgres is on another server, can the EM server connect to that other server?  Run a telnet from the EM server to the Postgres server to ensure communication is ok.  Also check if a firewall is blocking it.

3. Check your <EM Home>/config/tess-db-cfg.xml and check if the parameters are correct, especially the url.

4. Put your EM in DEBUG and restart.  Once you see that an attempt to connect to the db has happened, upload your log here and we can give it a quick look.

 

Thanks,
Matt

[Hallett German]

On the APM CE MOM GUI there is a test database button. Are you able to access it that way?

What is the operation before the error? Is this a temporary or ongoing condition?

What does the pg.logs say on the database side?

Also looking at the database supportability metrics in the Investigator may help.

 

Please review Matt's and these comments and advise next steps.

[Lynn Williams]

If everything suggested so far does not help you can also check the .../data/pg_log/postgresql-<date>.log file for any messages indicating why the EM connection is failing.

[Billy Cole]

check the configuration file on Postgresql

     /wilydb/database/data/pg_hba.conf

To insure that the accessing IP addresses are listed.  If they are not, add the source IP addresses and restart postgresql.

 

Hope that helps,

Billy

[Daniel Addo]

Thank you all so much for your contribution.

 

This issue is resolved.

 

 

Daniel Addo