Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page describes how to setup PostgreSQL database for your connection with Pathfinder.

Tip

Resources

Please install the following files:

You can find additional software, if required, here:

https://www.postgresql.org/download/product-categories/

For detailed guide on installation of PostgreSQL on Windows please visit: https://www.postgresqltutorial.com/install-postgresql/

For detailed guide on installation of PostgreSQL on Linux please visit: https://www.postgresqltutorial.com/install-postgresql-linux/

Note

Note: For database connection with Pathfinder, the root user account cannot be used.


Please follow the steps below to create a database for Pathfinder without root user.

  1. Install PostgreSQL database server.

  2. Create a user for the pathfinder database, e.g. "pathfinder".

  3. Create a database. e.g. "pathfinder", and make the new user the owner.

  4. Grant ALL privileges on the created database to the new user.

  5. Set the new user as the owner of the public schema on the new database.


You can now connect to the database using the Pathfinder database connection manager.

For information, go to: Configure the Client-Database Connection