wal_level logical for streaming replication

From: Vijaykumar Jain <vjain(at)opentable(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: wal_level logical for streaming replication
Date: 2019-08-28 16:14:24
Message-ID: CAE7uO5j6sMck0c-a-4DzLriY-q-fo_ASXUanDgnOUdBZn92O2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
--

Regards,
Vijay

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Lewis 2019-08-28 18:27:51 Re: [ext] Re: Pointers towards identifying bulk import bottleneck (walwriter tuning?)
Previous Message Christopher Browne 2019-08-28 16:06:26 Re: Work hours?