PostgreSQL

PostgreSQL documentation

1. Download the installation file.

2. Install the database

PostgreSQL Server

Command Line Tools

PG Admin (for easy access to the database)

The database has been installed and is now available without any specific configuration.

1. Open the pgAdmin.

2. Select the server on which you want to add a new database.

3. Right-click on the server.

4. Click on Create database.

Another window opens in which you can configure your database.

You have created a new database.

1. Use a text editor to open the file pg_hba.config in C:\Program Files\PostgreSQL\*version*\data\

2. Adjust the entry host all all 127.0.0.1/32 scram-sha-256 or add a new one.

By default, 127.0.0.1/32 is entered as local only. If other systems are to have access to the database, the corresponding IP address must be set.

3. Configure your firewall according to the port selected during installation (default: 5432/tcp).

Thanks to the new configuration, your database is now accessible over the network.