Обсуждение: [HACKERS] Postgres 9.6 Logical and Fisical replication
Hi guys I am working with Postgres9.6 with a Master/Slave cluster replication using Streaming replication. I would like to add a new Slave server database but this database with logical replication . I tried with some configurations but it was not possible :( https://github.com/guedim/postgres-streaming-replication Here is the image of what is in my mind: <http://www.postgresql-archive.org/file/t350419/Database_Replication.png> Thanks for any help! -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, Sep 18, 2017 at 5:30 PM, guedim <guedim@gmail.com> wrote: > I am working with Postgres9.6 with a Master/Slave cluster replication using > Streaming replication. > I would like to add a new Slave server database but this database with > logical replication . > > I tried with some configurations but it was not possible :( > > https://github.com/guedim/postgres-streaming-replication > > Here is the image of what is in my mind: > <http://www.postgresql-archive.org/file/t350419/Database_Replication.png> This question is really off-topic for this list, which is probably why you haven't gotten any replies. This list is for discussion of PostgreSQL development; there are other lists for user questions, like pgsql-general. Logical replication is only supported beginning in PostgreSQL 10; if you are using some earlier version, you need an add-on tool like pglogical, slony, etc. Please also read https://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Thank you for the clarification.
El 5/10/2017 9:27 AM, "Robert Haas" <robertmhaas@gmail.com> escribió:
On Mon, Sep 18, 2017 at 5:30 PM, guedim <guedim@gmail.com> wrote:
> I am working with Postgres9.6 with a Master/Slave cluster replication using
> Streaming replication.
> I would like to add a new Slave server database but this database with
> logical replication .
>
> I tried with some configurations but it was not possible :(
>
> https://github.com/guedim/postgres-streaming-replication
>
> Here is the image of what is in my mind:
> <http://www.postgresql-archive.org/file/t350419/ Database_Replication.png>
This question is really off-topic for this list, which is probably why
you haven't gotten any replies. This list is for discussion of
PostgreSQL development; there are other lists for user questions, like
pgsql-general. Logical replication is only supported beginning in
PostgreSQL 10; if you are using some earlier version, you need an
add-on tool like pglogical, slony, etc.
Please also read https://wiki.postgresql.org/wiki/Guide_to_reporting_ problems
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company