Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Scott Marlowe
On Sat, Jul 25, 2009 at 9:48 PM, Kevin Kempter wrote: > On Saturday 25 July 2009 20:05:14 Scott Marlowe wrote: >> On Sat, Jul 25, 2009 at 1:30 PM, Kevin >> >> Kempter wrote: >> > On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote: >> >> On Sat, Jul 25, 2009 at 1:08 PM, Kevin >> >> >> >> Kempter

Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Kevin Kempter
On Saturday 25 July 2009 20:05:14 Scott Marlowe wrote: > On Sat, Jul 25, 2009 at 1:30 PM, Kevin > > Kempter wrote: > > On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote: > >> On Sat, Jul 25, 2009 at 1:08 PM, Kevin > >> > >> Kempter wrote: > >> > On Saturday 25 July 2009 13:02:52 Scott Marlowe w

Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Scott Marlowe
On Sat, Jul 25, 2009 at 1:30 PM, Kevin Kempter wrote: > On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote: >> On Sat, Jul 25, 2009 at 1:08 PM, Kevin >> >> Kempter wrote: >> > On Saturday 25 July 2009 13:02:52 Scott Marlowe wrote: >> >> On Sat, Jul 25, 2009 at 12:55 PM, Kevin >> >> >> >> Kempter

Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Tom Lane
Kevin Kempter 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 director

Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Daniel Verite
Kevin Kempter wrote: > I suspect I need to run pg_resetxlog but I cannot find it anywhere, where > would > I find pg_resetxlog on a debian box that was installed via the deb packages > ? > or how do I get it ? It's under /usr/lib/postgresql/8.3/bin Best regards, -- Daniel PostgreSQL-p

Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Kevin Kempter
On Saturday 25 July 2009 13:23:54 Scott Marlowe wrote: > On Sat, Jul 25, 2009 at 1:08 PM, Kevin > > Kempter wrote: > > On Saturday 25 July 2009 13:02:52 Scott Marlowe wrote: > >> On Sat, Jul 25, 2009 at 12:55 PM, Kevin > >> > >> Kempter wrote: > >> > Hi all; > >> > > >> > I'm trying to restore from

Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Scott Marlowe
On Sat, Jul 25, 2009 at 1:08 PM, Kevin Kempter wrote: > On Saturday 25 July 2009 13:02:52 Scott Marlowe wrote: >> On Sat, Jul 25, 2009 at 12:55 PM, Kevin >> >> Kempter wrote: >> > Hi all; >> > >> > I'm trying to restore from a tar of the filesystem on a debian box and I >> > get xlog errors. >> > >

Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Kevin Kempter
On Saturday 25 July 2009 13:02:52 Scott Marlowe wrote: > On Sat, Jul 25, 2009 at 12:55 PM, Kevin > > Kempter wrote: > > Hi all; > > > > I'm trying to restore from a tar of the filesystem on a debian box and I > > get xlog errors. > > > > I suspect I need to run pg_resetxlog but I cannot find it any

Re: [GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Scott Marlowe
On Sat, Jul 25, 2009 at 12:55 PM, Kevin Kempter wrote: > Hi all; > > I'm trying to restore from a tar of the filesystem on a debian box and I get > xlog errors. > > I suspect I need to run pg_resetxlog but I cannot find it anywhere, where > would > I find pg_resetxlog on a debian box that was inst

[GENERAL] where is pg_resetxlog ?

2009-07-25 Thread Kevin Kempter
Hi all; I'm trying to restore from a tar of the filesystem on a debian box and I get xlog errors. I suspect I need to run pg_resetxlog but I cannot find it anywhere, where would I find pg_resetxlog on a debian box that was installed via the deb packages ? or how do I get it ? Thanks in adv