pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql stream replication question
3+ messages / 2 participants
[nested] [flat]
* postgresql stream replication question
@ 2012-05-03 05:47 sgm <sgm277@yahoo.com.cn>
0 siblings, 1 reply; 3+ messages in thread
From: sgm @ 2012-05-03 05:47 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql stream replication question
@ 2012-05-03 07:34 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: sgm <sgm277@yahoo.com.cn>
0 siblings, 1 reply; 3+ messages in thread
From: Devrim GÜNDÜZ @ 2012-05-03 07:34 UTC (permalink / raw)
To: sgm <sgm277@yahoo.com.cn>; +Cc: 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
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql stream replication question
@ 2012-05-03 08:05 sgm <sgm277@yahoo.com.cn>
parent: Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 0 replies; 3+ messages in thread
From: sgm @ 2012-05-03 08:05 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: pgsql-admin
Thank you sir.
--- 12年5月3日，周四, Devrim GÜNDÜZ <devrim@gunduz.org> 写道：
发件人: Devrim GÜNDÜZ <devrim@gunduz.org>
主题: Re: [ADMIN] postgresql stream replication question
收件人: "sgm" <sgm277@yahoo.com.cn>
抄送: pgsql-admin@postgresql.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-05-03 08:05 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-05-03 05:47 postgresql stream replication question sgm <sgm277@yahoo.com.cn>
2012-05-03 07:34 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2012-05-03 08:05 ` sgm <sgm277@yahoo.com.cn>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox