Marcos Lloret <marcos@second.ival.es> 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