pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan I make logical replication behave like synchronous streaming?
3+ messages / 3 participants
[nested] [flat]
* Can I make logical replication behave like synchronous streaming?
@ 2021-10-20 21:47 sbob <sbob@quadratum-braccas.com>
2021-10-21 05:50 ` Re: Can I make logical replication behave like synchronous streaming? Laurenz Albe <laurenz.albe@cybertec.at>
2021-10-21 13:18 ` Re: Can I make logical replication behave like synchronous streaming? Simon Riggs <simon.riggs@enterprisedb.com>
0 siblings, 2 replies; 3+ messages in thread
From: sbob @ 2021-10-20 21:47 UTC (permalink / raw)
To: pgsql-admin
All;
We are going to be replication across platforms (risc ti intel), so we
will be using logical replication (PostgreSQL v11)
However we need a sunchronous solution as opposed to async.
Does logical replication perform like synchronous streaming? If not can
I force it to do so?
Thanks in advance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can I make logical replication behave like synchronous streaming?
2021-10-20 21:47 Can I make logical replication behave like synchronous streaming? sbob <sbob@quadratum-braccas.com>
@ 2021-10-21 05:50 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 3+ messages in thread
From: Laurenz Albe @ 2021-10-21 05:50 UTC (permalink / raw)
To: sbob <sbob@quadratum-braccas.com>; pgsql-admin
On Wed, 2021-10-20 at 15:47 -0600, sbob wrote:
> Does logical replication perform like synchronous streaming? If not can
> I force it to do so?
Sure!
Set "application_name" to some name in the CONNECTION clause of
CREATE SUBSCRIPTION and use that name in "synchronous_standby_names"
on the primary.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can I make logical replication behave like synchronous streaming?
2021-10-20 21:47 Can I make logical replication behave like synchronous streaming? sbob <sbob@quadratum-braccas.com>
@ 2021-10-21 13:18 ` Simon Riggs <simon.riggs@enterprisedb.com>
1 sibling, 0 replies; 3+ messages in thread
From: Simon Riggs @ 2021-10-21 13:18 UTC (permalink / raw)
To: sbob <sbob@quadratum-braccas.com>; +Cc: pgsql-admin
On Wed, 20 Oct 2021 at 22:47, sbob <sbob@quadratum-braccas.com> wrote:
> We are going to be replication across platforms (risc ti intel), so we
> will be using logical replication (PostgreSQL v11)
>
> However we need a synchronous solution as opposed to async.
>
>
> Does logical replication perform like synchronous streaming? If not can
> I force it to do so?
Yes, it is designed to use the same connection interfaces.
https://www.postgresql.org/docs/devel/logical-replication-subscription.html
Note that sync rep in this mode is equivalent to synchronous_commit =
remote_apply.
--
Simon Riggs http://www.EnterpriseDB.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-10-21 13:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-20 21:47 Can I make logical replication behave like synchronous streaming? sbob <sbob@quadratum-braccas.com>
2021-10-21 05:50 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-10-21 13:18 ` Simon Riggs <simon.riggs@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox