Troubleshooting External Database Connection Issues

Product version: 10.9

Last modified: 6 April 2023


Connectivity problems when using an external product database.


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

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.



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