Обсуждение: postgresql stream replication question

Поиск
Список
Период
Сортировка

postgresql stream replication question

От
sgm
Дата:
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

Re: postgresql stream replication question

От
Devrim GÜNDÜZ
Дата:
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

Вложения

Re: postgresql stream replication question

От
sgm
Дата:
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