PostgreSQL
Documentation of PostreSQL
Installation:
- 1. Download the installation file.
- 2. Install the database
- PostgreSQL Server
- Command Line Tools
- PG Admin (for easy access to the database)
Creating a new database
- 3. Open the pgAdmin.
- 4. Select the server on which you want to add a new database.
- 5. Right-click the server.
- 6. Click on Create database.
- Another window opens in which you can configure your database.
Settings for access via the network
- 7. Open the file pg_hba.config in C:\Program Files\PostgreSQL\*version*\data\ with a text editor.
- 8. 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.
- 9. Configure your firewall according to the port selected during installation (default: 5432/tcp).