ipreg/pg-decode-dns-update.git
3 years agoSplit updates per zone master
Tony Finch [Fri, 23 Dec 2016 16:51:22 +0000 (16:51 +0000)]
Split updates per zone

3 years agoPlaying with DNS UPDATE from Perl
Tony Finch [Fri, 23 Dec 2016 15:48:19 +0000 (15:48 +0000)]
Playing with DNS UPDATE from Perl

3 years agoUse pg_logical_emit_message() for co-ordinating between batch and streaming DNS updates
Tony Finch [Thu, 22 Dec 2016 17:37:35 +0000 (17:37 +0000)]
Use pg_logical_emit_message() for co-ordinating between batch and streaming DNS updates

3 years agoA few more RR types
Tony Finch [Wed, 21 Dec 2016 16:38:45 +0000 (16:38 +0000)]
A few more RR types

3 years agoAvoid emitting an update verb with no RR.
Tony Finch [Wed, 21 Dec 2016 15:56:31 +0000 (15:56 +0000)]
Avoid emitting an update verb with no RR.

There's still a bit of inelegance that when we emit multiple update
commands, we don't do so as separate calls to OutputPluginWrite()
so they don't appear as separate lines in the table you get from
pg_logical_slot_get_changes(). Fixing that requires working out
ahead of time which write will be the last one...

3 years agoSome thoughts about memory allocaton
Tony Finch [Wed, 21 Dec 2016 15:35:52 +0000 (15:35 +0000)]
Some thoughts about memory allocaton

3 years agoNo need to keep cfgtbl around
Tony Finch [Wed, 21 Dec 2016 15:29:07 +0000 (15:29 +0000)]
No need to keep cfgtbl around

3 years agoCommentary
Tony Finch [Wed, 21 Dec 2016 15:09:19 +0000 (15:09 +0000)]
Commentary

3 years agoSupport ip4r column types
Tony Finch [Wed, 21 Dec 2016 14:46:07 +0000 (14:46 +0000)]
Support ip4r column types

3 years agoUpdate column types of config table
Tony Finch [Tue, 20 Dec 2016 18:30:12 +0000 (18:30 +0000)]
Update column types of config table

3 years agoAdd missing example SQL
Tony Finch [Tue, 20 Dec 2016 18:29:09 +0000 (18:29 +0000)]
Add missing example SQL

3 years agoGC old Jsonb gubbins
Tony Finch [Tue, 20 Dec 2016 18:28:15 +0000 (18:28 +0000)]
GC old Jsonb gubbins

3 years agoConstruct new internal version of configuration table
Tony Finch [Tue, 20 Dec 2016 18:00:30 +0000 (18:00 +0000)]
Construct new internal version of configuration table

3 years agoNote that safe switching from batch mode needs sentinel transactions on either side...
Tony Finch [Tue, 20 Dec 2016 13:34:57 +0000 (13:34 +0000)]
Note that safe switching from batch mode needs sentinel transactions on either side of the batch export.

3 years agoNotes on safe switching from batch to streaming updates
Tony Finch [Mon, 19 Dec 2016 11:42:31 +0000 (11:42 +0000)]
Notes on safe switching from batch to streaming updates

3 years agoBetter rationale
Tony Finch [Mon, 19 Dec 2016 11:25:21 +0000 (11:25 +0000)]
Better rationale

3 years agoNote about multiple translations
Tony Finch [Fri, 16 Dec 2016 23:20:09 +0000 (23:20 +0000)]
Note about multiple translations

3 years agoMarkup
Tony Finch [Fri, 16 Dec 2016 23:16:26 +0000 (23:16 +0000)]
Markup

3 years agoUpdate README
Tony Finch [Fri, 16 Dec 2016 23:14:41 +0000 (23:14 +0000)]
Update README

3 years agoPrune redundant variables
Tony Finch [Fri, 16 Dec 2016 22:38:28 +0000 (22:38 +0000)]
Prune redundant variables

3 years agoPrune test messages
Tony Finch [Fri, 16 Dec 2016 22:20:47 +0000 (22:20 +0000)]
Prune test messages

3 years agoCNAME and PTR support
Tony Finch [Fri, 16 Dec 2016 21:58:12 +0000 (21:58 +0000)]
CNAME and PTR support

3 years agoIPv4 and IPv6 support
Tony Finch [Fri, 16 Dec 2016 21:46:34 +0000 (21:46 +0000)]
IPv4 and IPv6 support

3 years agoGetting there...
Tony Finch [Fri, 16 Dec 2016 21:29:18 +0000 (21:29 +0000)]
Getting there...

3 years agoNested transactions do not in fact work
Tony Finch [Fri, 16 Dec 2016 20:55:26 +0000 (20:55 +0000)]
Nested transactions do not in fact work

I was confused because a persistent server process did not reload the
decoding output plugin - I needed to disconnect from the server and
reconnect to force a reload.

3 years agoPer-RRtype decoding functions
Tony Finch [Fri, 16 Dec 2016 20:55:08 +0000 (20:55 +0000)]
Per-RRtype decoding functions

3 years agoCheck config for changes of interest
Tony Finch [Fri, 16 Dec 2016 18:43:43 +0000 (18:43 +0000)]
Check config for changes of interest

3 years agoCode layout tweaks
Tony Finch [Fri, 16 Dec 2016 17:47:10 +0000 (17:47 +0000)]
Code layout tweaks

3 years agoTweak error message
Tony Finch [Fri, 16 Dec 2016 17:19:19 +0000 (17:19 +0000)]
Tweak error message

3 years agoNested transactions seem to be working now
Tony Finch [Fri, 16 Dec 2016 17:16:27 +0000 (17:16 +0000)]
Nested transactions seem to be working now

3 years agoCopy Jsonb config into correct memory context
Tony Finch [Fri, 16 Dec 2016 17:09:23 +0000 (17:09 +0000)]
Copy Jsonb config into correct memory context

The private data->context is used for building the output text
and is frequently reset, which destroys anything inside it!
So copy the Jsonb to the parent logical decoding context.

3 years agoCleanup commit output and don't bother quoting literals
Tony Finch [Fri, 16 Dec 2016 17:06:36 +0000 (17:06 +0000)]
Cleanup commit output and don't bother quoting literals

3 years agoNo need to print BEGIN
Tony Finch [Fri, 16 Dec 2016 16:08:50 +0000 (16:08 +0000)]
No need to print BEGIN

3 years agoWe are not interested in pg_logical_emit_message
Tony Finch [Fri, 16 Dec 2016 16:05:09 +0000 (16:05 +0000)]
We are not interested in pg_logical_emit_message

3 years agoStart renaming things more nicely
Tony Finch [Fri, 16 Dec 2016 15:56:56 +0000 (15:56 +0000)]
Start renaming things more nicely

3 years agoCopy Jsonb config to the right memory context
Tony Finch [Fri, 16 Dec 2016 15:46:54 +0000 (15:46 +0000)]
Copy Jsonb config to the right memory context

3 years agoSimplify Jsonb configuration object
Tony Finch [Fri, 16 Dec 2016 14:00:44 +0000 (14:00 +0000)]
Simplify Jsonb configuration object

3 years agoExperimental digging inside Jsonb
Tony Finch [Thu, 15 Dec 2016 19:10:50 +0000 (19:10 +0000)]
Experimental digging inside Jsonb

3 years agoGet Jsonb from our config table
Tony Finch [Thu, 15 Dec 2016 18:56:05 +0000 (18:56 +0000)]
Get Jsonb from our config table

3 years agoProgress?
Tony Finch [Thu, 15 Dec 2016 17:22:21 +0000 (17:22 +0000)]
Progress?

3 years agoTidier config handling. Still broken!
Tony Finch [Thu, 15 Dec 2016 16:58:09 +0000 (16:58 +0000)]
Tidier config handling. Still broken!

3 years agoTrim down option handling
Tony Finch [Thu, 15 Dec 2016 14:44:39 +0000 (14:44 +0000)]
Trim down option handling

3 years agoNested transactions work, so no need for it to be conditional
Tony Finch [Thu, 15 Dec 2016 13:55:46 +0000 (13:55 +0000)]
Nested transactions work, so no need for it to be conditional

3 years agoInitial hack at getting SPI to work in the startup callback
Tony Finch [Thu, 15 Dec 2016 13:53:16 +0000 (13:53 +0000)]
Initial hack at getting SPI to work in the startup callback

3 years agoRename plugin and add a trivial Makefile
Tony Finch [Wed, 14 Dec 2016 16:13:51 +0000 (16:13 +0000)]
Rename plugin and add a trivial Makefile

3 years agoImport test_decoding from PostgreSQL
Tony Finch [Wed, 14 Dec 2016 15:48:03 +0000 (15:48 +0000)]
Import test_decoding from PostgreSQL

3 years agoInitial notes on my plans and progress so far...
Tony Finch [Wed, 14 Dec 2016 15:40:01 +0000 (15:40 +0000)]
Initial notes on my plans and progress so far...

3 years agoSketchy Ansible playbook for setting up test environment.
Tony Finch [Wed, 14 Dec 2016 15:32:30 +0000 (15:32 +0000)]
Sketchy Ansible playbook for setting up test environment.

3 years agoStart
Tony Finch [Mon, 12 Dec 2016 18:49:23 +0000 (18:49 +0000)]
Start