make us of old database.

From: Marcos Lloret <marcos(at)second(dot)ival(dot)es>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: make us of old database.
Date: 2000-06-07 17:21:05
Message-ID: 393E8480.BAD77D3@second.ival.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)ival(dot)es

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mihai Gheorghiu 2000-06-07 17:57:25 Re: Dump
Previous Message Steve Wampler 2000-06-07 17:20:27 plpgsql question...