Re: [PERFORM] Pas la samedi

2004-06-24 Thread Laurent Martelli
Laurent == Laurent Rathle [EMAIL PROTECTED] writes: Laurent Le mardi 22 Juin 2004 19:59, Giancarlo a écrit : 1ere règle: il n'y a pas de CVS chez Parinux 2eme règle: il n'y a pas de CVS chez Parinux, et... 3eme règle: il n'y a pas de CVS chez Parinux ;-) Bon en fait c

Re: [PERFORM] after using pg_resetxlog, db lost

2004-06-24 Thread Shea,Dan [CIS]
I determined the largest was 12,293,162 and set it to pg_resetxlog -x 1500 /var/lib/pgsql/data I am now able to see all the data. I actually checked the log for the previous successfull startup before it the pg_control file was reset and it reported Jun 22 11:55:44 pascal postgres[24993]:

Re: [PERFORM] after using pg_resetxlog, db lost

2004-06-24 Thread Tom Lane
Shea,Dan [CIS] [EMAIL PROTECTED] writes: I determined the largest was 12,293,162 and set it to pg_resetxlog -x 1500 /var/lib/pgsql/data Okay, but it looks like you will also need to adjust pg_clog to cover that transaction ID range. (I had thought pg_resetxlog would handle this for you,