ERROR: WAL level not sufficient for making an online backup

Hi,

The reason getting bellow error is relevant your postgres.conf file.

ERROR:  WAL level not sufficient for making an online backup
HINT:  wal_level must be set to "replica" or "logical" at server start.

If you faced it, you should check status of was_level and archive_mode in Postgres.conf file, you can find it under postgresql's data file.

Check both of two rows in your file;

wal_level = replica
archive_mode = on

Loves,

Comments

Popular posts from this blog

PostgreSQL High Availability - Patroni 2

PostgreSQL Foreign Data Wrappers

PostgreSQL High Availability - Patroni 1