wal_level
unable to set wal_level on self hosted docker instance.
As well including reloading
other output
so it is just set to logical, still outputs replica.
root@78fa86f53bbf:/# psql -U supabase_admin -h localhost -d postgres <<EOF
> ALTER SYSTEM SET wal_level = 'logical';
> EOF
ALTER SYSTEM
root@78fa86f53bbf:/# psql -U supabase_admin -h localhost -d postgres -c "SHOW wal_level;"
wal_level
-----------
replica
(1 row)root@78fa86f53bbf:/# psql -U supabase_admin -h localhost -d postgres <<EOF
> ALTER SYSTEM SET wal_level = 'logical';
> EOF
ALTER SYSTEM
root@78fa86f53bbf:/# psql -U supabase_admin -h localhost -d postgres -c "SHOW wal_level;"
wal_level
-----------
replica
(1 row)As well including reloading
psql -U supabase_admin -h localhost -d postgres <<EOF
ALTER SYSTEM SET wal_level = 'logical';
SELECT pg_reload_conf();
EOF
psql -U supabase_admin -h localhost -d postgres -c "SHOW wal_level;"psql -U supabase_admin -h localhost -d postgres <<EOF
ALTER SYSTEM SET wal_level = 'logical';
SELECT pg_reload_conf();
EOF
psql -U supabase_admin -h localhost -d postgres -c "SHOW wal_level;"other output
root@78fa86f53bbf:/etc/postgresql# grep "wal_level" /etc/postgresql/*
/etc/postgresql/postgresql.conf:wal_level = logical # minimal, replica, or logicalroot@78fa86f53bbf:/etc/postgresql# grep "wal_level" /etc/postgresql/*
/etc/postgresql/postgresql.conf:wal_level = logical # minimal, replica, or logicalso it is just set to logical, still outputs replica.
