Testing Database Access

The estimate command can be used to verify that the PostgreSQL Plugin is well configured.

* estimate listing job=pg-test
...

If estimate or the job output displays the following error:

Error: Can't reach PostgreSQL server to get database config.

the next steps should be to verify that the Bacula Enterprise PostgreSQL plugin can retrieve information using the psql command as “postgres” user on the Client.

To verify if the “postgres” user can connect to the PostgreSQL Cluster, the psql -l command can be used, and it should list all databases in the Cluster:

postgres%  psql -l
   List of databases
   Name    |  Owner   |
-----------+----------+
postgres   |   xxx
template0  |   xxx
template1  |   xxx

If options such as -h localhost are needed on the psql command line, a service file as described in servicecon will be required.

See also

Go back to:

• Automatic Objects Configuration

• PITR Configuration

• Dump Configuration

• Service Connection Information

Go back to the main PostgreSQL Configuration page.

Go back to the Dedicated Backup Solutions page.