Re: Is my db dead ? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Is my db dead ?
Date
Msg-id 20080205151941.GC4066@alvh.no-ip.org
Whole thread Raw
In response to Is my db dead ?  (dawmette@gmail.com)
Responses Re: Is my db dead ?
Re: Is my db dead ?
List pgsql-general
dawmette@gmail.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

pgsql-general by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Universal libpq.a ?
Next
From: Alvaro Herrera
Date:
Subject: Re: Universal libpq.a ?