Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] CREATE SUBSCRIPTION documentation - Mailing list pgsql-hackers

From Jeff Janes
Subject [HACKERS] CREATE SUBSCRIPTION documentation
Date
Msg-id CAMkU=1xNOxJM1fRcbEfN8hq=UGky_FDx-TKL7fe+ow1BaTRHjg@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] CREATE SUBSCRIPTION documentation  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view

Has the note:

See Section 26.2.5.1 for details on how to configure access control between the subscription and the publication instance.

But that section seems to describe authentication for physical, not logical, replication.  Those two no longer use the same access control methods.  For logical replication, the role has to have replication attribute or be a superuser, but the role does not need to have replication listed in the pg_hba.conf.

I think it would be better to instead reference:


And on that page, it says:

"The role used for the replication connection must have the REPLICATION attribute"

Should also say something like "or be a superuser".  It is bit tedious to say that everywhere, but the docs are supposed to be a bit tedious.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] GSoC 2017 weekly progress reports (week 3)
Next
From: Shubham Barai
Date:
Subject: Re: [HACKERS] GSoC 2017 weekly progress reports (week 3)