Postgres Streaming replication (version:9.4) - Mailing list pgsql-odbc

From Mallela, Anil
Subject Postgres Streaming replication (version:9.4)
Date
Msg-id 068F35352B68EA4E9E2FF825B506585F062237@MX201CL02.corp.emc.com
Whole thread Raw
Responses Re: [SQL] Postgres Streaming replication (version:9.4)  (Jayadevan M <maymala.jayadevan@gmail.com>)
List pgsql-odbc

Hi,

           PostgreSQL master/slave Streaming replication is working fine .I also changed slave as master using trigger file.

I need some clarification on the below 2 scenarios:

1. once slave become master whatever the tables are created in new master it’s not replicated to old master, how to replicate the same from new master to old master

2. How to make old master as slave (which should accept  read only transactions)

 

Can you please help me regarding this and  also tell me is the above approach is valid or not.

I have tried  3 nodes(master/slave)—master(bring down master)/make it slave as master/and created new slave  and it is working fine.

Thanks,

Anil.

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: [PATCH] Regression test failures on big endian
Next
From: Christoph Berg
Date:
Subject: Re: [PATCH] Regression test failures on big endian