I am having problems disabling the generation of WAL files in a non-productive database.
Although in the postgresql.conf file I have disabled WAL generation, I see that they are still generated with any DML statement executed.
In the configuration file I have modified these options:
wal_level = logical archive_mode = off archive_command = false
I have tried to restart the DB and still, WAL files are still generated. If I access the DB, I can see that it is deactivated:
[local] postgres@db1=# select name,setting from pg_settings where name like 'archive%' ; name setting ----------------------- ---------- archive_cleanup_command archive_command (disabled) archive_mode off archive_timeout 0 (4 rows)