Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseβ€’3y agoβ€’
1 reply
tr1cks

wal_level

unable to set wal_level on self hosted docker instance.

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 logical
root@78fa86f53bbf:/etc/postgresql# grep "wal_level" /etc/postgresql/*
/etc/postgresql/postgresql.conf:wal_level = logical                     # minimal, replica, or logical


so it is just set to logical, still outputs replica.
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

How long does it take for the WAL to reset? / How to clear the WAL?
SupabaseSSupabase / help-and-questions
4mo ago
Using WAL‑G in Docker with Supabase
SupabaseSSupabase / help-and-questions
8mo ago
Project level Access?
SupabaseSSupabase / help-and-questions
2w ago
Column level security
SupabaseSSupabase / help-and-questions
3y ago