]
Subject: Re: [PERFORM] after using pg_resetxlog, db lost
"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
tha
"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
--
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 23, 2004 11:41 PM
To: Shea,Dan [CIS]
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] after using pg_resetxlog, db lost
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes:
> Tom I see you from past emails that you reference u
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes:
> Tom I see you from past emails that you reference using -i -f with
> pg_filedump. I have tried this, but do not know what I am looking at.
What you want to look at is valid XMIN and XMAX values. In this
example:
> Item 1 -- Length: 196 Offset:
:36 PM
To: Shea,Dan [CIS]
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] after using pg_resetxlog, db lost
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes:
> The pg_resetxlog was run as root. It caused ownership problems of
> pg_control and xlog files.
> Now we have no acce
Richard Huxton <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> This could be repaired by doing
>> pg_resetxlog with a more appropriate initial transaction ID, but
>> figuring out what that value should be is not easy :-(
> Tom - would there be any value in adding this to a pg_dump?
Possibly. CV
Tom Lane wrote:
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes:
The pg_resetxlog was run as root. It caused ownership problems of
pg_control and xlog files.
Now we have no access to the data now through psql. The data is still
there under /var/lib/pgsql/data/base/17347 (PWFPM_DEV DB name). But
ther
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes:
> The pg_resetxlog was run as root. It caused ownership problems of
> pg_control and xlog files.
> Now we have no access to the data now through psql. The data is still
> there under /var/lib/pgsql/data/base/17347 (PWFPM_DEV DB name). But
> there is n