Re: Is my db dead ?

["Eric Renard" <dawmette@xxxxxxxxx>]

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 <alvherre@xxxxxxxxxxxxxxxxx> wrote:

dawmette@xxxxxxxxx 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

Attachment: pg_control
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly