PostgreSQL

Requirements for using PostgreSQL with Synece

Manage access

• Create a dedicated user and give it the super user role as Synece requires a superuser to create a PostgreSQL publication for all tables

postgresql.conf

• Set your wal_level to logical then restart your PostgreSQL instance

pg_hba.conf

• You may have to create an entry in your pg_hba.conf file to allow the new user to connect (host database user synece_given_address auth-method, see here)

Tuning your WAL settings

Please see PGTune