Skip site navigation (1) Skip section navigation (2)

Re: replication is not working

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jai Soni <jai(dot)soni(at)elbizsystems(dot)com>
Cc: pgsql-testers(at)postgresql(dot)org
Subject: Re: replication is not working
Date: 2010-08-25 19:40:17
Message-ID: 201008251940.o7PJeH621683@momjian.us (view raw or flat)
Thread:
Lists: pgsql-testers
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 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 

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

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

In response to

pgsql-testers by date

Next:From: Steve SingerDate: 2010-09-03 16:52:00
Subject: 9.0rc1 Solaris binaries on opensolaris
Previous:From: Bruce MomjianDate: 2010-08-25 15:11:08
Subject: Re: feature request in postgresql 9.0 release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group