10. Postgres Resources

The Postgres plug-in attempts to log into the database server using the username and password of postgres. In many installations, this is a default superuser and will work. However, it is also possible that this login could fail for several different reason:

To resolve this:

Additionally, Postgres may need to be changed on Red Hat Enterprise Linux systems to allow password based logins by changing settings in the pg_hba.conf file.

In many installations, Postgres will not start its statistics collector by default. To enable statistics collection, add or change the following line in the postgres.conf file:

stats_start_collector = on

stats_start_collector = on

Each Postgres database inventoried in JBoss ON requires one connection.

With the frequency of availability and statistics monitoring, the Postgres plug-in keeps an open connection to the database. When attempting to drop a database currently inventoried in JBoss ON, an error is thrown about the database being in use. To drop the database, the JBoss ON agent monitoring the database must be shut down or the database resource should be removed from JBoss ON. This will close the postgres plug-in's connection to the Postgres server and allow you to drop the database.