Ok in fact, the times weird thing were because I copied the data dir on a 64 bits arch and it went from a 32 bit arch. On the 32 bit one : pg_control version number: 812 Catalog version number: 200510211 Database system identifier: 4989617165674917617 Database cluster state: in production pg_control last modified: Mon 04 Feb 2008 20:43:33 CET Current log file ID: 0 Next log file segment: 34 Latest checkpoint location: 0/2109832C Prior checkpoint location: 0/210982E8 Latest checkpoint's REDO location: 0/2109832C Latest checkpoint's UNDO location: 0/0 Latest checkpoint's TimeLineID: 1 Latest checkpoint's NextXID: 1315262 Latest checkpoint's NextOID: 34543 Latest checkpoint's NextMultiXactId: 1 Latest checkpoint's NextMultiOffset: 0 Time of latest checkpoint: Mon 04 Feb 2008 20:05:40 CET Maximum data alignment: 4 Database block size: 8192 Blocks per segment of large relation: 131072 Bytes per WAL segment: 16777216 Maximum length of identifiers: 64 Maximum columns in an index: 32 Date/time type storage: 64-bit integers Maximum length of locale name: 128 LC_COLLATE: fr_FR.utf8 LC_CTYPE: fr_FR.utf8
Everything seems ok but I still can't see 99% of my data. No error msg, nothing special, just a ton of relations does not exist and empty or almost empty tables. On Feb 5, 2008 4:19 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] escribió: > > My server crashed yesterday, the hd was saved though and I was able to > > get a copy of the data directory of my pg cluster. On the server now, > > when I start pg, I can see only like 1% of my data, there are many dbs/ > > tables and rows missing. But the data dir seems ok in size though. So > > I copied the whole data dir to a new serv, installed the same pg > > version but now I can't get it started at all. There are some weird > > things in the pg_controldata : > > > > pg_control last modified: Tue 03 Sep 6869 17:57:36 CET > > Time of latest checkpoint: Thu 11 Jan 1116953 03:46:31 CET > > LC_COLLATE: > > LC_CTYPE: > > What's the full pg_controldata output? Can you send the pg_control file > as a binary attachment? > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom Development, 24x7 support >
pg_control
Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
