Re: where is pg_resetxlog ? - Mailing list pgsql-general

From Tom Lane
Subject Re: where is pg_resetxlog ?
Date
Msg-id 15863.1248558450@sss.pgh.pa.us
Whole thread Raw
In response to Re: where is pg_resetxlog ?  (Kevin Kempter <kevink@consistentstate.com>)
List pgsql-general
Kevin Kempter <kevink@consistentstate.com> writes:
> On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote:
>> Did you rsync the pg_xlog and pg_clog (i.e. EVERYTHING under data/) or
>> just the base directory?  You really need to do an rsync of
>> everything, not most everything.

> we rsync'ed EVERYTHING (the entire directory and all sub-dirs)

Those log entries are proof positive that you forgot pg_xlog.

Maybe you had pg_xlog/ symlinked to someplace else on the old server
and forgot to replicate that arrangement on the new one?

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Using unnest
Next
From: Tom Lane
Date:
Subject: Re: Using unnest