Troubleshooting External Database Connection Issues

Product version: 10.9

Last modified: 6 April 2023

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:

1. Stop NAKIVO Backup & Replication.

2. Find the configuration file located in [Product location]/userdata/config.properties and open it.

3. 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

4. Restart the external database on the same or different host (as specified above).

5. 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.

Multiple problems, such as connection problem or inability to create or edit new tenants in Multi-Tenant mode, may also occur due to the exceeded number of concurrent PostgreSQL connections. The default number of connections for PostgreSQL is 100 for single tenant and per tenant in Multi-Tenant mode. If you are experiencing any issues while having over 100 connections, do the following:

1. Find the postgresql.conf file in PostgreSQL/12/data folder.

2. Increase max_connections to match or exceed the number of active jobs in NAKIVO Backup & Replication.

3. Restart the external database host.

4. Restart NAKIVO Backup & Replication.

 

Note

The following also increase the number of connections to the database:

• Adding existing or creating new Transporters

• Adding existing or creating new Repositories

• Adding inventory items

• Adding new users

• Adding new tenants