Re: Built-in plugin for logical decoding output

On 25/09/17 22:08, Jignesh Shah wrote:
>
>
> On Mon, Sep 25, 2017 at 11:37 AM, Joshua D. Drake
> <jd(at)commandprompt(dot)com <mailto:jd(at)commandprompt(dot)com>> wrote:
>
> On 09/25/2017 11:31 AM, Alvaro Hernandez wrote:
>
>
>
> Whether or not they are included in a managed environment
> is generally based on two things:
>
>     1. Safety (why RDS doesn't allow certain C extensions)
>     2. Community/Popularity (Exactly why RDS has PostGIS)
>         A. Demand with a prerequisite of #1
>
>
>      This is very clear. Now tell me: how many output plugins
> do you see included in RDS. And in GCP's PostgreSQL? Azure
> Postgres? Heroku?
>
>
> From RDS:
>
> Logical Replication for PostgreSQL on Amazon RDS
>
> Beginning with PostgreSQL version 9.4, PostgreSQL supports the
> streaming of WAL changes using logical replication slots. Amazon
> RDS supports logical replication for a PostgreSQL DB instance
> version 9.4.9 and higher and 9.5.4 and higher. Using logical
> replication, you can set up logical replication slots on your
> instance and stream database changes through these slots to a
> client like pg_recvlogical. Logical slots are created at the
> database level and support replication connections to a single
> database.
>
> PostgreSQL logical replication on Amazon RDS is enabled by a new
> parameter, a new replication connection type, and a new security
> role. The client for the replication can be any client that is
> capable of establishing a replication connection to a database on
> a PostgreSQL DB instance.
>
> The most common clients for PostgreSQL logical replication are AWS
> Database Migration Service or a custom-managed host on an AWS EC2
> instance. The logical replication slot knows nothing about the
> receiver of the stream; there is no requirement that the target be
> a replica database. Note that if you set up a logical replication
> slot and do not read from the slot, data can be written to your DB
> instance's storage and you can quickly fill up the storage on your
> instance.
>
> """
>
> I don't see why others wouldn't be available either. In fact, I am
> not sure why you couldn't use the JSON ones now. (Although I have
> not tested it).
>
> JD
>
>
>
>
>
> Also to add, Amazon RDS for PostgreSQL does supports non-core
> plugins.  Wal2json output plugin for logical decoding is supported for
> versions 9.6.3+ and 9.5.7+  (link
> <http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.version963>)
> .
>

    I think that's awesome. Now... back to my original question: what
is the *list* of output plugins supported by managed PostgreSQL
solutions? So far it looks like wal2json for 9.5-9.6 on RDS, and nothing
else (it may just be not complete, but in the best case this list won't
be unfortunately long...).

    Álvaro

--

Alvaro Hernandez

-----------
OnGres