| 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: | Whole Thread | Raw Message | 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 |