[ADMIN] Question about PITR backup

2012-06-08 Thread sgm
Dear admin, I have a question about PITR backup in a single server, the method is make a base backup, and backup the WAL archive log(eg, every day at 11:30 pm). But if the OS' harddisk is broken(eg,14:00 pm),the system can't start, we have to recover the database on a another server using the ba

Re: [ADMIN] postgresql stream replication question

2012-05-04 Thread sgm
Thank you sir. --- 12年5月3日,周四, Devrim GÜNDÜZ 写道: 发件人: Devrim GÜNDÜZ 主题: Re: [ADMIN] postgresql stream replication question 收件人: "sgm" 抄送: 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 r

[ADMIN] postgresql stream replication question

2012-05-03 Thread 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