My main disk for Postgresql crashed but I still have the database as it was stored on a tablespace on another disk. Now the problem is how to recover from this situation. What I have tried is to restore the database from a backup from a few houres before the crash and then replacing the directory within the pgsql-data/base directory holding the database with the version of the database from the uncorrupted disk. When I try to access the database I get ERROR: could not access status of transaction 1827968 DETAIL: could not open file "/home/software/postgres/DATA/pg_clog/0001": No such file or directory How can I solve this inconsistency and recover the database? :) Thanks! Geir. ------------------------------------------------------------------------- Start.no tilbyr nå raskere bredbånd til lavere pris. Sjekk http://www.start.no/bredband/ for mer informasjon ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
