Hello Team,
wal_level = logical
wal_level = replica
As per docs,
wal_level determines how much information is written to the WAL. The default value is replica, which writes enough data to support WAL archiving and replication, including running read-only queries on a standby server. minimal removes all logging except the information required to recover from a crash or immediate shutdown. Finally, logical adds information necessary to support logical decoding. Each level includes the information logged at all lower levels. This parameter can only be set at server start.
I have had a combination where I had to upgrade a server using logical replication and when it was done I had replicas serving read queries of the server with wal level logical.
All fine.
I have two dumb queries .
If I change wal_level back to replica, will it corrupt wal? coz it will then be having diff information ( r format of data ?)
What is the base reason as to why ddls are not sent via logical replication but the hot standby has ddl changes reflected absolutely fine ?
and there is one large limitation on large object support for logical replication?
Where can I see the limitation on size or is it just certain data types ?
I used this to generate dummy data of in a table of all data types it only 1000 rows and it replicated fine.
I could easily stress more on this, but I did not want to do discovery and spread rumours without known references.
Appreciate your help as always.
Thanks,
Vijay
--