| From: | "Mallela, Anil" <anil(dot)mallela(at)emc(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Mike Sofen <msofen(at)runbox(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Postgres Streaming replication (version:9.4) |
| Date: | 2016-04-06 11:53:01 |
| Message-ID: | 068F35352B68EA4E9E2FF825B506585F062237@MX201CL02.corp.emc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inoue, Hiroshi | 2016-04-06 13:03:48 | Re: [PATCH] Regression test failures on big endian |
| Previous Message | Christoph Berg | 2016-04-05 11:47:56 | Re: [PATCH] Regression test failures on big endian |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Moore | 2016-04-06 20:07:12 | Re: Geometry vs Geography (what to use) |
| Previous Message | Lee Hachadoorian | 2016-04-06 02:16:33 | Re: Geometry vs Geography (what to use) |