| From: | dawmette(at)gmail(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Is my db dead ? |
| Date: | 2008-02-05 14:56:29 |
| Message-ID: | 7c3a980b-c84c-4fc6-8abb-f09151152182@e10g2000prf.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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:
So now I can't start the server because of the blank locale :
Starting PostgreSQL 8.1 database server: main* Error: The server must
be started under the locale : which does not exist any more.
Soo... Is there a chance for me to see again my data ? What can I do
to fix this ?
Thanks for any suggestions
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Larry Rosenman | 2008-02-05 15:03:21 | Re: Universal libpq.a ? |
| Previous Message | Dan Langille | 2008-02-05 14:10:25 | Re: [Cert] Re: PostgreSQL Certification |