You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, I tested subscription to a standby with the HEAD of the repo (pglogical 2.4.5, pending release).
I'm noticing pglogical seems to create subscriptions with failover as long as its supported on the node (by checking catalog).
So unlike PG 16, now the subscription cannot succeed, with error messages like
ERROR: cannot enable failover for a replication slot created on the standby
...
STATEMENT: CREATE_REPLICATION_SLOT "pgl_postgres_provider_testsub" LOGICAL pglogical_output (FAILOVER)
I was curious if this kind of behavior is expected?
The text was updated successfully, but these errors were encountered:
Hi, I tested subscription to a standby with the HEAD of the repo (pglogical 2.4.5, pending release).
I'm noticing pglogical seems to create subscriptions with failover as long as its supported on the node (by checking catalog).
pglogical/pglogical_sync.c
Lines 900 to 904 in c3507a8
pglogical/pglogical_sync.c
Lines 308 to 311 in c3507a8
But with PG 17, that isn't supported if its a standby.
https://github.com/postgres/postgres/blob/bccca780eef904002512a1a0b5ce617bcb63507b/src/backend/replication/slot.c#L330-L333
So unlike PG 16, now the subscription cannot succeed, with error messages like
I was curious if this kind of behavior is expected?
The text was updated successfully, but these errors were encountered: