Product Version: 10.7
Last Modified: 19 August 2022
Problem
Connectivity problems when using an external product database.
Solutions
If you are encountering connection issues, try the following to re-establish a connection to an external database:
- Stop NAKIVO Backup & Replication.
- Find the configuration file located in [NBR location]/userdata/config.properties and open it.
- Update database info (host, port, database name, username, and password, bolded below in that order) within the following 3 keys:
- database.url=jdbc\:postgresql\://localhost\:5432/nakivo2021?useUnicode\=true&characterEncoding\=UTF-8
- database.usr=postgres
- database.pass=admin
- Restart the external database on the same or different host (as specified above).
- Restart NAKIVO Backup & Replication.
Note
If the database was broken, you will need to restore from self-backup. To restore from self-backup or export bundle, users can install a new NAKIVO Backup & Replication, switch to a new external database, and then restore from the self-backup or export bundle.
The connection problem may also occur due to the exceeded number of concurrent PostgreSQL connections. The default number of connections for PostgreSQL is 100. If you are experiencing connection issues while having over 100 active jobs, do the following:
- Increase max_connections to match or exceed the number of active jobs in NAKIVO Backup & Replication.
- Restart the external database host.
- Restart NAKIVO Backup & Replication.