Re: Is my db dead ?

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(at)commandprompt(dot)com> wrote:

> dawmette(at)gmail(dot)com 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
>