Re: [GENERAL] How to use pg_resetxlog if data directory is in c:/Program Files ?

2007-03-08 Thread Shoaib Mir
Try using something like this --> "Program Files/PostgreSQL/data" (that is with quotes for using spaces) -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 3/8/07, Steven De Vriendt <[EMAIL PROTECTED]> wrote: Hi all, Got this kind of silly question. I'm trying to use pg_resetxlog. Problem

Re: [GENERAL] How to use pg_resetxlog if data directory is in c:/Program Files ?

2007-03-07 Thread Steven De Vriendt
Thank you very much Shoaib, that worked fine ! Regards, Steven On 3/8/07, Shoaib Mir <[EMAIL PROTECTED]> wrote: Try using something like this --> "Program Files/PostgreSQL/data" (that is with quotes for using spaces) -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 3/8/07, Steven De V

Re: [GENERAL] how to use pg_resetxlog

2003-10-24 Thread Johnson, Shaunn
Title: RE: [GENERAL] how to use pg_resetxlog --Thanks to all that replied --I did the pg_resetxlog -f $PGDATA and --it generated a new log, but when I try to --restart the database, it fails.  I look in the --logs and I see: [snip] Oct 21 01:32:13 localsvr postgres[2598]: [1] FATAL 2

Re: [GENERAL] how to use pg_resetxlog

2003-10-21 Thread Johnson, Shaunn
Title: RE: [GENERAL] how to use pg_resetxlog --silly question: --is it possible to build a new DB and point it to --the existing location  / files of the old DB --and mount data that way? --i know ...  i'm grasping for straws ... this is --just about a retarded / rhetorical que