| From: | Kristaps Armanis <krisha(at)grafton(dot)lv> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Restoring fscked up postgres 7.1 |
| Date: | 2005-01-21 15:45:05 |
| Message-ID: | 12179534609.20050121174505@grafton.lv |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Friday, January 21, 2005, 5:30:07 PM, Jus rakstijat:
MvO> Looks like XID wraparound, you hit the 4 billion transaction mark. This
MvO> was fixed in 7.2 IIRC. Unfortunatly I don't know of an easy way to
MvO> recover, but this should give you something to search the archives for.
Till how sorted that out already.
I hyave copy of old one..
Latest checkpoint's NextXID: 2669533222
Latest checkpoint's NextOID: 26300179
Time of latest checkpoint: Fri Jan 21 16:00:48 2005
Database block size: 8192
Blocks per segment of large relation: 131072
--------------
And then it's just:
Latest checkpoint's NextXID: 2747597
Latest checkpoint's NextOID: 282132
Time of latest checkpoint: Fri Jan 21 03:32:17 2005
Is there any solution?
___________________________________
Kristaps Armanis
Grafton Entertainment :: IT director
Brivibas Str. 214m, Riga LV1039, Latvia
e-mail: krisha(at)grafton(dot)lv
web: http://www.tvnet.lv
phn: +371 7819577
gsm: +371 9474932
fax: +371 7819578
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pallav Kalva | 2005-01-21 16:15:25 | Postgres 8.0 Log Configuration |
| Previous Message | Haron, Charles | 2005-01-21 15:43:00 | Re: Trouble Escaping Quotes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric E | 2005-01-21 16:04:05 | Re: PL/TCL functions won't run - resolved |
| Previous Message | Marco Colombo | 2005-01-21 15:41:57 | Re: Multiline plpython procedure |