pglogical

pglogical copied to clipboard

Running CREATE INDEX CONCURRENTLY on subscriber can break subscription (subscriber: postgres 15.6 + pglogical 2.4.4) - error message in logs: could not read block 0 in file ""base/[DB_OID]/[IDX_RELATION_FILENODE]"": read only 0 of 8192 bytes

1

I don't have a minimal repro for this right now, but the symptom I have observed on a subscriber that I am syncing for an upgrade is: * (context) I...

aristocrates

Bug: Race condition causes data loss in pglogical_create_subscriber

2

When using `pglogical_create_subscriber` to create a new logical subsrciber, there is a race condition between the two processes updating/reading the `sync_status` field of `pglogical.local_sync_status`. The two processes are: - the...

ruoshan

Skip generated columns as these are not COPY-able Currently pglogical is unable to replicate tables with generated columns, this pull request fixes this

postsql

Followed the README; When trying to install the “2ndQuadrant’s General Public” repository by running the following as root `curl https://techsupport.enterprisedb.com/api/repository/dl/default/release/deb | bash` ``` root@debian-12:~# curl https://techsupport.enterprisedb.com/api/repository/dl/default/release/deb | bash % Total...

n0obHere

I am using pg9.6. I need to move a provider to a new server, I plan to dump old sql and run the sql on the new server/databse. So technically,...

jingjingan

eulerto

Missing slot_name option at create_subscription function.

1

I have multiple patroni clusters with physical replication which allows me to create cluster-wide persistent replication slot via [`slots` directive](https://patroni.readthedocs.io/en/master/dynamic_configuration.html#dynamic-configuration). I'm missing directive to specify `slot_name` at `create_subscription` to achieve...

dusatvoj

Hello, I have database which I want to replicate to another cluster. I created replication and added all tables from `public` schema. ``` select pglogical.replication_set_add_all_tables('default', ARRAY['public'],true); ``` In other schema...

dusatvoj

Repositories from enterprisedb "not found"

1

All repositories for rpm installs are not working https://techsupport.enterprisedb.com/api/repository/dl/default/release//rpm response: "not found"

aljazvidmar

Hi there, Postgres 17beta1 has been released by community, and current version does not support that. May I know when we can have the 17 supported version published? Thanks! current...

Deltaus