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...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...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...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...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...Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2024 and are licensed for use under CC BY-NC-ND 4.0.