[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] [GENERAL] Restoring fscked up postgres 7.1
From: Kristaps Armanis <krisha () grafton ! lv>
Date: 2005-01-21 15:45:05
Message-ID: 12179534609.20050121174505 () grafton ! lv
[Download RAW message or body]
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@grafton.lv
web: http://www.tvnet.lv
phn: +371 7819577
gsm: +371 9474932
fax: +371 7819578
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic