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