Hello! I had problems with my HDD and i have lost many files. From my pgsql database files I have only "base"-folder. In this folder one is important database: base/45325101
I reinstall my postgresql-server. I have created new database with same name and have copied all files from my old folder to new folder. I have successful connect to this database, but when I try to browse my tables, I see error message: ERROR: could not access status of transaction 18651428 DETAIL: could not open file "/var/db/pgsql/pg_clog/0011": No such file or directory How to correct this one database? ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match