Setup and installation of PostgreSQL
- Abir Haque
- Thomas Wais
- Vanina Soprano
This page describes how to setup PostgreSQL database for your connection with Pathfinder.
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: 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.
Install PostgreSQL database server.
Create a user for the pathfinder database, e.g. "pathfinder".
Create a database. e.g. "pathfinder", and make the new user the owner.
Grant ALL privileges on the created database to the new user.
Set the new user as the owner of the public schema on the new database.
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