| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Srinivasa T N <seenutn(at)gmail(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Both type of replications from a single server? |
| Date: | 2020-10-08 08:01:02 |
| Message-ID: | 20201008080102.GE3457@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 08, 2020 at 01:25:14PM +0530, Srinivasa T N wrote:
> For streaming replication, I need to set wal_level to replica in A whereas
> for logical_replication we need to set wal_level to replica in the same A
> server. So, was wondering how to go about?
A logical replica needs wal_level = logical, a setting that also
allows to do streaming replication for a physical replica. But the
opposite is not true, as using wal_level = replica will not work for
logical replicas. So, assuming that you want to have both logical and
physical replicas that replicate from the same source server, you need
to set wal_level to logical on the primary server because it is a
system-wide configuration.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Marc Lessard | 2020-10-08 14:57:34 | Does the work made by vaccum in the current pass is lost when interrupted? |
| Previous Message | Srinivasa T N | 2020-10-08 07:55:14 | Re: Both type of replications from a single server? |