Marcos Lloret <[EMAIL PROTECTED]> writes: > i want to make us of an old recovered database from a dead hard > disk. i just copied the directory > /usr/local/pgsl/data/base/[database-name] > i install postgres 6..4 (as before) and i created a new database > directory and copied all the database. That's not going to work, at least not that way. You need to have a pg_log file that has the same set of transaction commit and abort records that were in your old database. Basically, you can transfer an *entire* pgsql/data tree by copying it, but you don't get to pick and choose parts. regards, tom lane