search

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 153 forks source link

Upgraded to RHEL2.0 unable to update existing installation, unable to drop extension #103

Closed asr1901 closed 7 years ago

asr1901 commented 7 years ago

I installed the new pglogical 2.0 on our RHEL databases. Previously we were using 1.2. However, 'alter extension update' shows this error: ERROR: cache lookup failed for relation pglogical.depend

I could live with re-creating my replication sets, etc. so I did:

DROP EXTENSION pglogical CASCADE;

This also fails with the error: ERROR: cache lookup failed for relation pglogical.depend

Any ideas how I can get logical replication working again? I am completely stuck, unable to drop the extension to recreate replication sets and similarly unable to upgrade my extension.

In the meantime, even trying to recreate my old subscriptions with the upgraded binaries (but non-updated pglogical extension) fails.

Additionally, my error logs on both the subscriber and primary are filled with this:

LOG: manager worker [12770] at slot 0 generation 60 crashed LOG: worker process: pglogical manager 21705 (PID 12770) exited with exit code 1 LOG: unregistering background worker "pglogical manager 21705"

PJMODOS commented 7 years ago

Yes, sorry for that, 2.0.1 will fix it soon (the code is already in the REL2_0_STABLE branch).