Thread: make us of old database.

hi list,

    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.
    > psql [database-name]
            and no problem
    \d       it displays the tables and indexes.
    select * from [table-name];
            ERROR:  [table-name]: Table does not exist.
            ERROR:  [table-name]: Table does not exist.

    what can i do in order to solve the problem??'

    thanks in advance,

marcos
marcos@ival.es

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