TwinCAT/BSD

	These instructions refer to version 17 of PostgreSQL.

Installation of PostgreSQL

Connect to the FreeBSD® PackageManager to install the appropriate package.

1. Open the configuration file "FreeBSD.conf".

doas ee /usr/local/etc/pkg/repos/FreeBSD.conf

2. Change the value "enabled" to yes.

3. Update the packages.

You will now see the available FreeBSD packages.

doas pkg update

4. Search for the PostgreSQL database server.

doas pkg search postgresql17

5. Install the PostgreSQL database server.

doas pkg install postgresql17-server-17.x_x

6. Activate the PostgreSQL service.

The database has been successfully installed and the service has been set up in the autostart.

doas sysrc postgresql_enable="YES"

Initializing PostgreSQL

1. Initialize the database.

doas /usr/local/etc/rc.d/postgresql initdb

2. Start the database service.

doas service postgresql start

3. Switch to the database user

doas -u postgres psql

4. Change the default password of postgres

\password postgres

5. Exit psql

The database has been successfully initialized and started.

\q

Settings for access via the network

1. Open pf.conf to configure the firewall.

doas ee /etc/pf.conf

2. Add the port 5432.

pass in quick proto tcp to port 5432 keep state

3. Save and exit the editor.

4. Reload the firewall configuration.

Port 5432 has been opened in the firewall.

doas pfctl -f /etc/pf.conf

5. Open postgresql.conf to adjust the "listen_addresses".

doas ee /var/db/postgres/data17/postgresql.conf

6. Change the entry listen_addresses to '*' and remove the # to activate the line.

# - Connection Settings -

listen_addresses = '*'          # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost'; use '*' for all
                                        # (change requires restart)

7. Save and exit the editor.

8. Open pg_hba.conf to adjust the security settings.

doas ee /var/db/postgres/data17/pg_hba.conf

9. Adjust the entry host all all 127.0.0.1/32 or add a new one. Change the method to md5.

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.
Notice Alternatively, 0.0.0.0/0 can be used as the IP address, in which case all requests will be allowed. This can pose a safety risk!

# TYPE  DATABASE        USER            ADDRESS                  METHOD
# "local" is for Unix domain socket connections only
local   all             all                                      trust
# IPv4 local connections:
host    all             all             127.0.0.1/32             trust
# IPv6 local connections:
host    all             all             ::1/128                  trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                      trust
host    replication     all             127.0.0.1/32             trust
host    replication     all             ::1/128                  trust

10. Save and exit the editor.

11. Restart the service.

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

doas service postgresql restart