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

Document procedure for updating pglogical #85

Closed chad-earthscope closed 7 years ago

chad-earthscope commented 7 years ago

I could not find any instructions for updating pglogical to a new release. Perhaps there is some general/tribal knowledge about updated extensions that applies, but for those of us not used to updating extensions on operational systems knowing the correction procedure (restart required?, re-definition of subscriptions, etc.? hot-patch possible?) would be very valuable.

Ideally some instructions would go or be linked from here: https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/

Hopefully I haven't missed something obvious. Thanks for the great pglogical work!

jfinzel commented 7 years ago

Basically, the extension is updated like any other postgres extension: you install the new packages on the target server and run ALTER EXTENSION UPDATE, but it does require a restart to actually load the updated C code because it uses shared_preload_libraries: https://www.postgresql.org/docs/9.5/static/sql-alterextension.html

chad-earthscope commented 7 years ago

OK, those a just the details we need. I humbly recommend that it's worth a small section in the docs for pglogical. thanks!

PJMODOS commented 7 years ago

Agreed, we'll add that section.