PostgreSQL Database Requirements

Requirements for a user-managed PostgreSQL database.

If you want Seeker to use your own fully-managed PostgreSQL database instance, make sure that it meets the following requirements:

Area Requirements/Considerations
Database version Version 10.2 or higher, including 14.5.
Operating system requirements Server System Requirements
Schemas Seeker uses the default schema determined by the search_path for the Seeker PostgreSQL user, both during setup and at runtime.
Role privileges The Seeker PostgreSQL user doesn't need any role privileges for normal operation. Only two specific use cases require the following elevated privileges:
  • If the user has the superuser privileges, Seeker will use the pgstattuple PostgreSQL extension to monitor the database and perform routine vacuuming.
  • Seeker automatically includes databases of less than 100MB size in diagnostic dumps. This requires the user to have the pg_read_all_settings or superuser privileges.
Encoding The database must be encoded using UTF-8.
Collation The supported locales for both LC_CTYPE and LC_COLLATE settings are based on UTF8, UTF-8, EN-us, or English. For example, English_United_States.1252 or de_DE.utf8.
Parameter configuration The minimal values of the following configuration parameters in the postgresql.conf file are: 
shared_buffers = 512MB
work_mem = 32MB
max_connections = 120