From: | sagar koirala <sagarkoirala25(at)hotmail(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Error in starting PostgreSQL Server 7.4 after crash |
Date: | 2008-09-22 02:56:08 |
Message-ID: | BAY109-W79993C6438773D2415180DD4B0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
It all started like this:
My postgresql 7.4 running in CentOS crashed with one database missing in all my backups. But, I have a copy of the entire pgsql/data directory (which is unforunately a version grabbed while the server was still running...)
I need to recover that database and I have tried the following:
Installed postgre 7.4 again and replaced the new data folder with the one from my backup, didn't work: postgresql service couldn't start.
So, I used pg_resetxlog PGDATA with PGDATA pointing to my current /pgsql/data. It said transaction log reset. At this point, the postgresql is not running, so I cannot dump my old data. Starting the postgresql doesn't work.
So I tried: export PGDATA=/var/lib/pgsql/data
Then I tried to pg_ctl start but ended up with following message:
-bash-3.00$ pg_ctl start
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with BLCKSZ 6330300, but the server was compiled with BLCKSZ 8192.
HINT: It looks like you need to recompile or initdb.
postmaster successfully started
-bash-3.00$
Any suggestions? Thanks in advance.
_________________________________________________________________
Stay up to date on your PC, the Web, and your mobile phone with Windows Live.
http://clk.atdmt.com/MRT/go/msnnkwxp1020093185mrt/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-09-22 03:39:17 | Re: Error in starting PostgreSQL Server 7.4 after crash |
Previous Message | Guillaume Smet | 2008-09-20 10:39:52 | Re: BUG #4428: renaming tables, columns and fk cheks problem |