Tom, thank you for your help.
I increased 000E to 81920 and the databse is working now.
We are using RHAS 3.0 and it does have /dev/zero.
Dan.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 12:34 PM
To: Shea,Dan [CIS]
Cc: [EMAIL PROTECTED]
Subjec
"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 y
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]:
> "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
>>
>> ;-)
>
