Michael Paquier - PostgreSQL committer

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

Make a logical receiver behave as a synchronous standby

2014-10-26 04:03:34 +0000

Logical decoding is a superset of the existing standby protocol. Hence after decoding changes from WAL an output plugin can shape it in any kind of ways, making for example possible to have a plugin that does the exact revert operation of the decoding portion a PostgreSQL server instancedid by reproducing similar WAL records that could be replayed similarly to a standby. Not sure if this would be actually useful, but well that’s possible…

Read more...

Postgres 9.5 feature highlight - Replication slot control with pg_receivexlog

2014-10-16 06:20:37 +0000

Introduced in PostgreSQL 9.4, [pg_recvlogical] (https://www.postgresql.org/docs/devel/static/app-pgrecvlogical.html) has the ability to control the creation of logical replication slots from which logical changes can be streamed. Note that in the case this is a mandatory condition when using [logical decoding] (https://www.postgresql.org/docs/devel/static/logicaldecoding.html). [pg_receivexlog] (https://www.postgresql.org/docs/devel/static/app-pgreceivexlog.html) does not have in 9.4 any control on the physical replication slots it may stream from (to ensure that the WAL segment files this utility is looking for are still retained on the server side). This feature has been added for 9.5 with the following commit:

Read more...

Postgres 9.5 feature highlight - SKIP LOCKED for row-level locking

2014-10-10 07:10:44 +0000

SKIP LOCKED is a new feature associated with [row-level locking] (https://www.postgresql.org/docs/devel/static/explicit-locking.html#LOCKING-ROWS) that has been newly-introduced in PostgreSQL 9.5 by this commit:

Read more...

Postgres 9.5 feature highlight - Row-Level Security and Policies

2014-10-03 14:20:36 +0000

Row-level security is a new feature of PostgreSQL 9.5 that has been introduced by this commit:

Read more...

Postgres 9.5 feature highlight - Improved verbose logs in pg_dump

2014-09-28 14:24:56 +0000

The following simple commit has improved the verbose logs of [pg_dump] (https://www.postgresql.org/docs/devel/static/app-pgdump.html) (the ones that can be invocated with option -v and that are useful to keep a log trace when using cron jobs kicking pg_dump), by making the schema names of the relations dumped show up as well:

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.