PostgreSQL

This tool will install and start a PostgreSQL server. Click "Install PostgreSQL" to install the version available through your system's package manager.

Once installed, Lifeboat can create superusers. To add a superuser click the [ + ] button below the user list. To remove a user, select the username and click the [ - ] button below the user list.

Click the "Options" button to configure additional options for PostgreSQL. On this view are controls to change the port, enable external access, and stop the PostgreSQL database server.

Enabling external access will open the PostgreSQL port with the firewall that Lifeboat installed. Be sure any external firewalls allow the PostgreSQL port as well. The port cannot be changed while external access is enabled. Disable external access to change the port setting.

Due to a technical limitation, Lifeboat can only manage users when PostgreSQL is running on the default port 5432 on CentOS 7.

Why this version of PostgreSQL?

The version of PostgreSQL that Lifeboat will offer to install is dictated by the package manager for the Linux system. The PostgreSQL version will vary from flavor to flavor.

Linux Flavor	PostgreSQL
CentOS 7	9.6
Debian 9	9.6
Debian 10	11
Debian 11	13
Debian 12	15
Ubuntu 18.04	10
Ubuntu 20.04	12
Ubuntu 22.04	14