Michael Paquier - PostgreSQL committer

  • Home
  • Manuals
  • Presentations
  • Projects
  • Resume
  • Tags
  • About

Postgres 9.4 feature highlight - MSVC installer for client binaries and libraries

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...

Postgres 9.4 feature highlight - Creating an output plugin for logical replication

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...

Postgres 9.4 feature highlight - REPLICA IDENTITY and logical replication

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...

Postgres 9.4 feature highlight - Basics about logical decoding

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...

Testing heartbleed on Postgres

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...

« Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Next »

Search

Social

Github

Mastodon

Twitter

RSS Feeds

Main

Postgres

Sponsor

Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2023 and are licensed for use under CC BY-SA 3.0.