> For the complete documentation index, see [llms.txt](https://docs.synece.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.synece.com/supported-databases/postgresql.md).

# PostgreSQL

### 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](https://www.postgresql.org/docs/current/auth-pg-hba-conf.html#id-1.6.8.8.2))

### Tuning your WAL settings

Please see [PGTune](https://pgtune.leopard.in.ua/)