Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-18 Thread Suzuki Hironobu
I guessed the master was in slave mode, because I thought configuration file had no problem, and the FATAL message was written when the slave connects to the master. However, I think that slave's parameter:hot_standby is off, because you can connect to the master. Regards, (13/09/13 0:58

Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-12 Thread Suzuki Hironobu
Which value does pg_is_recovery() return on the primary server? (13/09/13 0:58), AI Rumman wrote: Yes, I can access to the primary server perfectly. On Thu, Sep 12, 2013 at 11:55 AM, Suzuki Hironobuwrote: Hi, (13/09/12 23:53), AI Rumman wrote: Hi, I am trying to setup replication wit

Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-12 Thread AI Rumman
Yes, I can access to the primary server perfectly. On Thu, Sep 12, 2013 at 11:55 AM, Suzuki Hironobu wrote: > Hi, > > > (13/09/12 23:53), AI Rumman wrote: > >> Hi, >> >> I am trying to setup replication with Postgresql 9.2 in Ubuntu on Amazon >> Ec2. >> But stuck in the process. >> Postgresql

Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-12 Thread Michael Paquier
On Thu, Sep 12, 2013 at 7:53 AM, AI Rumman wrote: > psql > 2013-09-12 14:48:04 UTC FATAL: the database system is starting up > > I configured replication for Centos so many times and followed those steps. > Is there something I am missing? Perhaps hot_standby = on in the slave's postgresql.conf?

Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-12 Thread Suzuki Hironobu
Hi, (13/09/12 23:53), AI Rumman wrote: Hi, I am trying to setup replication with Postgresql 9.2 in Ubuntu on Amazon Ec2. But stuck in the process. Postgresql standby log is showing: 2013-09-12 14:45:47 UTC LOG: entering standby mode 2013-09-12 14:45:47 UTC LOG: redo starts at 1/3920 2013

[GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-12 Thread AI Rumman
Hi, I am trying to setup replication with Postgresql 9.2 in Ubuntu on Amazon Ec2. But stuck in the process. Postgresql standby log is showing: 2013-09-12 14:45:47 UTC LOG: entering standby mode 2013-09-12 14:45:47 UTC LOG: redo starts at 1/3920 2013-09-12 14:45:47 UTC LOG: record with zero