Thread: replication is not working

replication is not working

From
Jai Soni
Date:
Dear pgsql-testers

i have installed postgresql 9.0 and testing its streaming replication feature
for some reasons i have issued pg_resetxlog in my standby server and after doing this replication is not working in standby server
however the standby server is starte dnormally here is the log from standby server
LOG:  database system is ready to accept read only connections
LOG:  streaming replication successfully connected to primary

but updates from primary server is not reflected in standby server

kindly check this issue

Thanks
Jai Soni
P Please consider the environment before printing this email.

Re: replication is not working

From
Bruce Momjian
Date:
Jai Soni wrote:
> Dear pgsql-testers
>
> i have installed postgresql 9.0 and testing its streaming replication feature
> for some reasons i have issued pg_resetxlog in my standby server and after doing this replication is not working in
standbyserver  
> however the standby server is starte dnormally here is the log from standby server
> LOG:? database system is ready to accept read only connections
> LOG:? streaming replication successfully connected to primary
>
> but updates from primary server is not reflected in standby server

I don't think you can run pg_resetxlog on the standby.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +