2014-05-14 12:41:17 +0000
Today here is a highlight of a new Postgres 9.4 feature interesting for developers and companies doing packaging of Postgres on Windows as it makes possible the installation of client-only binaries and libraries using MSVC. It has been introduced by this commit:
Read more...2014-04-30 13:15:43 +0000
Continuing on the series of posts about logical replication and after looking at [some basics] (/postgresql-2/postgres-9-4-feature-highlight-basics-logical-decoding/) and the concept of [REPLICA IDENTITY] (/postgresql-2/postgres-9-4-feature-highlight-replica-identity-logical-replication/) for a table, now is time to begin more serious things by having a look at how to develop an output plugin for the logical decoding facility.
Read more...2014-04-24 13:53:43 +0000
Among the many things to say about logical replication features added in PostgreSQL 9.4, REPLICA IDENTITY is a new table-level parameter that can be used to control the information written to WAL to identify tuple data that is being deleted or updated (an update being a succession of an insert and a delete in MVCC).
Read more...2014-04-17 07:18:27 +0000
The second huge feature coming in PostgreSQL 9.4 with [jsonb] (postgresql-2/postgres-9-4-feature-highlight-indexing-jsonb/) is called [logical decoding] (https://www.postgresql.org/docs/devel/static/logicaldecoding.html). In short, it is a new plugin facility that can be used to decode changes that happen on a database and stream them to external sources. It can be used for many things like replication, auditing or even online upgrade solutions.
Read more...2014-04-12 05:07:04 +0000
Except if you have been cut from the Internet the last week, you have already heard of Heartbleed. This good candidate for the “Bug of the Year 2014” price is already costing a better-not-to-count amount of money in maintenance and development for many companies around the world.
Read more...Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2025 and are licensed for use under CC BY-NC-ND 4.0.