Обсуждение: replication is not working

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

replication is not working

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

От
Bruce Momjian
Дата:
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. +