3 ms·

> I’m pleased to say that we’ve just released Postgres-BDR 1.0, based on PostgreSQL 9.4.9. While I'm still excited to play with it, I can't wait until pglogica

> I’m pleased to say that we’ve just released Postgres-BDR 1.0, based on PostgreSQL 9.4.9. While I'm still excited to play with it, I can't wait until pglogical comes into mainline.

reitanqild 10y ago
Wow, that sounds like a really nice open-source company. They offer sources, repos for both apt and yum as well as this: > Need more help? > Click here for pglogical's documentation. > Click here to look at answers to some of the most frequently asked questions. > Want to know even more? Need some help to implement pglogical? As the developers we're probably the best people in the world to help you get up and running with pglogical. We have consultants available to provide assistance, plus our unique 24/7 Production Support subscription service also covers pglogical. That's a company I'd want to deal with. (Not using postgres at the moment, but hired Tomitribe for some minor work and the whole experience of dealing with the people who actually write and maintain stuff instead of marketing drones etc is totally awesome.)
colanderman 10y ago
Thanks for pointing out pglogical. I've never heard of it before, and it's exactly what we need to support online upgrade.
continuations 10y ago
How does pglogical differ from PostgreSQL's built-in streaming or log-shipping replication?
- pinaraf 10y ago
  PostgreSQL streaming : send disk diffs over network, raw binary, absolutely unusable if you don't have the same postgresql version on the other side Logical : send data diffs over network. Could be used for replication, but also audit or sending to different databases...
- martinmarques 10y ago
  pglogical works over the logical decoding code introduced in 9.4, so instead of sending over binary changes of the data files (SR just sends a change that says change these bytes on page X -- well, not super exact, but it gives you a picture of whats done), while logical decoding will read the WAL log, decode the changes so you can apply them else were by some plugin (pglogical would serve as a plugin in this case). I think the best way to show how it would work (and this is not what pglogical does as it would be inefficient) is by writing a plugin that feeds the logical decoded changes from the WAL and builds SQL statements from them UPDATE, INSERT, DELETE, etc. You could easily apply those on any other PostgreSQL server, or maybe even some other SQL server. Very handy for online upgrades.

> I’m pleased to say that we’ve just released Postgres-BDR 1.0, based on PostgreSQL 9.4.9. While I'm still excited to play with it, I can't wait until pglogical comes into mainline.

reitanqild 10y ago

Wow, that sounds like a really nice open-source company. They offer sources, repos for both apt and yum as well as this: > Need more help? > Click here for pglogical's documentation. > Click here to look at answers to some of the most frequently asked questions. > Want to know even more? Need some help to implement pglogical? As the developers we're probably the best people in the world to help you get up and running with pglogical. We have consultants available to provide assistance, plus our unique 24/7 Production Support subscription service also covers pglogical. That's a company I'd want to deal with. (Not using postgres at the moment, but hired Tomitribe for some minor work and the whole experience of dealing with the people who actually write and maintain stuff instead of marketing drones etc is totally awesome.)

colanderman 10y ago

Thanks for pointing out pglogical. I've never heard of it before, and it's exactly what we need to support online upgrade.

continuations 10y ago

How does pglogical differ from PostgreSQL's built-in streaming or log-shipping replication?

pinaraf 10y ago
PostgreSQL streaming : send disk diffs over network, raw binary, absolutely unusable if you don't have the same postgresql version on the other side Logical : send data diffs over network. Could be used for replication, but also audit or sending to different databases...
martinmarques 10y ago
pglogical works over the logical decoding code introduced in 9.4, so instead of sending over binary changes of the data files (SR just sends a change that says change these bytes on page X -- well, not super exact, but it gives you a picture of whats done), while logical decoding will read the WAL log, decode the changes so you can apply them else were by some plugin (pglogical would serve as a plugin in this case). I think the best way to show how it would work (and this is not what pglogical does as it would be inefficient) is by writing a plugin that feeds the logical decoded changes from the WAL and builds SQL statements from them UPDATE, INSERT, DELETE, etc. You could easily apply those on any other PostgreSQL server, or maybe even some other SQL server. Very handy for online upgrades.