Re: make us of old database.

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