| Lists: | pgsql-admin |
|---|
| From: | sgm <sgm277(at)yahoo(dot)com(dot)cn> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | postgresql stream replication question |
| Date: | 2012-05-03 05:47:52 |
| Message-ID: | 1336024072.75926.YahooMailClassic@web15608.mail.cnb.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Dear admin,
I have successfully set up the stream replication M1--IP1, M2---IP2, my question is if the master is down, the slave will become read and write by trigger file, but the client will connect to the IP2,right?
Thanks,
Song
| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | sgm <sgm277(at)yahoo(dot)com(dot)cn> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgresql stream replication question |
| Date: | 2012-05-03 07:34:00 |
| Message-ID: | 1336030440.4812.54.camel@lenovo01-laptop03.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
On Thu, 2012-05-03 at 13:47 +0800, sgm wrote:
> I have successfully set up the stream replication M1--IP1, M2---IP2,
> my question is if the master is down, the slave will become read and
> write by trigger file, but the client will connect to the IP2,right?
No. You will need something else (like Red Hat Cluster Suite) for that.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
| From: | sgm <sgm277(at)yahoo(dot)com(dot)cn> |
|---|---|
| To: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgresql stream replication question |
| Date: | 2012-05-03 08:05:08 |
| Message-ID: | 1336032308.94842.YahooMailClassic@web15607.mail.cnb.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Thank you sir.
--- 12年5月3日，周四, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> 写道：
发件人: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
主题: Re: [ADMIN] postgresql stream replication question
收件人: "sgm" <sgm277(at)yahoo(dot)com(dot)cn>
抄送: pgsql-admin(at)postgresql(dot)org
日期: 2012年5月3日,周四,下午3:34
On Thu, 2012-05-03 at 13:47 +0800, sgm wrote:
> I have successfully set up the stream replication M1--IP1, M2---IP2,
> my question is if the master is down, the slave will become read and
> write by trigger file, but the client will connect to the IP2,right?
No. You will need something else (like Red Hat Cluster Suite) for that.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz