pglogical

pglogical copied to clipboard

We're migrating data from AWS Postgres RDS v10.6 to AWS Aurora postgres 13.4 across accounts and have setup replication using pglogical such that any new data written into postgres is...

PenguinFlyingHigh

Hello, I have a database cluster that crashed in a way I don’t understand. Some details about the setup: The database that crashed is running Postgres 14.1 This database has...

Viralshah009

Could not open relation with OID

3

Pglogical 2.3.4 + postgresql 12 Open new psql connection to database. Run commands: ``` create extension pglogical; select * from pglogical.create_node( node_name := 'node1', dsn := 'host=/tmp/ dbname=my_database' ); select...

DenisRazinkin

I am running pg_logical on postgres 14 to bring data from postgres 11. ``` # rpm -qa|grep pglogical pglogical_14-2.4.1-1.rhel8.x86_64 ``` I was able to create a publisher, subscriber, and a...

adimania

Hello Team, We have enabled the pglogical replication between the on-prem(`Postgresql 13.6, pglogical 2.4`) and RDS aurora (`Postgresql 12.4, pglogical 2.3.2`) which is working fine. But when we execute the...

gowthamakanthan

Let's say: I have a provider node and a subscriber node; and some replication tables configured in the provider node. And I need to move provider node from old machine...

jingjingan

UPDATEs are not replicated ((tuple not found). Resolution: skip.)

1

Updates from **TABLE A**(PK column is integer) are correctly replicated but for **TABLE B**(PK varying(36)) all updates are failed with the same data: PostgresSQL version: - provider: 13.3 - subscriber:...

oleksandrg

Hello, I dropped pglogical after migration. But when we drop a view on public schema. I still got `permission denied for schema pglogical` error. After some search. Look like pglogical...

alantang888

Why do I get replication origin "pgl_____ngine_..." does not exist error when setup pglogical

1

I have two postgresql 11.9 and 13.4. The node, replica_set and subscription are all created successfully in both clusters. However, when I check the subscription status in the target database,...

zhaoyi0113

Issue i am facing is as follows I am on Ubuntu 20.04,postgresql 14 ,Pglogical for postgres 14 I have 35 branches and one regional site. All branches including regional sites...

PKadayaprath2018