< All Topics

Database Backup

In the Fleet Manager it is possible to set up a secondary system or a separate database on another pc as a backup. This can be run at a scheduled interval or on demand.

Note: In order to backup to another PC on your network you will require an installation of Postgres on the target machine with username of postgres and a password of postgres. You must also ensure that your Postgres installation will accept connections from anywhere on the network, as by default it only allows connections from itself. This is covered later in this article.

In order to complete this you will need the following:

  1. Access through a web browser (Edge, Chrome, Firefox) to the FleetManager Provisioning Tool.
  2. A secondary Fleet Manager system connected to the same network, or a database configured* on a locally accessible PC.
Database backup page
  • To access the page, along the top navigation go to DbBackup.

  • Network IP – This is the IP address of another PC on your network to back up to.

    Backup FM IP – IP address of the secondary Fleet Manager to write the backup to.

  • Choose an interval for the backup to run. If you do not wish for a recurring interval, choose None.

    Press Save when you have entered your settings.

  • Instant Backup – Run a back up immediately using the current configuration.

Postgres install welcome
  • Download and run the PostgreSQL installer for your platform. The Setup wizard will walk you through installation.

  • Click Next.

To use a separate Windows PC for the Fleet Manager backup, you must install PostgreSQL. The following will guide you through installation on a Windows PC.

Choosing an install directory
  • Specify the directory where you wish to install PostgreSQL.

  • Click Next.

Select components to install
  • Ensure PostgreSQL Server, pgAdmin, Stack Builder, and Command Line Tools are checked.

  • Click Next.

Data directory location
  • Specify the location in which to store your data files.

  • Click Next.

Database password setup
  • When asked to provide a password for the database superuser (postgres) enter postgres in both boxes.

    Note that if you do not specify a password of postgres the database backup will not work.

  • Click Next.

Port configuration
  • Ensure port number 5432 is entered.

  • Click Next.

Locale configuration
  • Select Default Locale.

  • Click Next.

Pre-install summary
  • The Pre Installation summary will show your installation settings.

  • Click Next.

Ready to install
  • When ready to install, click Next and wait for the installation to complete.

Successful install complete
  • Once the install is completed, uncheck Launch Stack Builder at exit.

  • Click Finish.

Opening pgAdmin from the start menu
  • From the Start Menu begin searching for pgAdmin and open the application.

Once PostgreSQL is installed you will need to connect to the database to finish set up. On the PC you installed PostgreSQL, open pgAdmin.

pgAdmin home screen
  • If you expand Servers you should see a server named PostgreSQL.

If prompted for a password, enter postgres and continue.

Connect to server
  • Right-click on the server named PostgreSQL and choose Connect to Server.

  • If prompted for a password, enter postgres and press OK.

You must connect to a server before you can modify it.

General properties
  • Once connected, right-click on the server named PostgreSQL and choose Properties.

  • On the General tab, provide a name.

Server connect properties
  • Choose the Connection tab.

  • Ensure the following values are set:

    Host name/address –

    Port – 5432

    Maintenance Database – postgres

    Username – postgres

  • Press Save.

pg data configuration file
  • In Windows File Explorer locate the pg_hba.conf file. This will be located in the data directory chosen during installation. In the example case, this is: C:\Program Files\PostgreSQL\16\data

  • Open the pg_hba.conf file in notepad or another text editor.

By default, PostgreSQL will only allow connections from itself. This must be changed in order for the FleetManager Database backup to function properly.

Editing pg_hba.conf file
  • In your text editor, scroll to the bottom and locate the IPv4 local connections option. Modify the IP address from to

  • Choose File > Save

Table of Contents