Versions Compared

Old Version 4

changes.mady.by.user Vanina Soprano

Saved on

compared with

New Version Current

changes.mady.by.user Thomas Wais

Saved on

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:

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.

Tip

It is possible to use a custom schema instead of public starting in Pathfinder 3.8. If a schema with the same name as the database user exists, that will be used. To use a custom schema you can alter the search_path for the database user in postgres.

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

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