[QUESTION]: Recovery of tables

Поиск
Список
Период
Сортировка
От Mark Lawrence
Тема [QUESTION]: Recovery of tables
Дата
Msg-id Pine.LNX.4.21.0104251023470.722-100000@null
обсуждение исходный текст
Ответ на Question: Recovery of tables  (Mark Lawrence <nomad@null.net>)
Ответы Rebuilding database from table files  (Mark Lawrence <nomad@null.net>)
Список pgsql-general
Hi,

I have a problem:

Due to a mismanaged upgrade I'm in the situation of having a
$PGDATA/base/template1 directory without any of the files from the $PGDATA
directory itself.

Using the unix 'strings' command I can see the data inside the actual
template1 database table files, however I can't get to the data using
postgresql.

I have tried a fresh install, recreating the tables, copying the old
template1 directory over the new but all queries return empty (no) rows.
Any ideas on how I can use the original table files to regain my data?

Thanks in advance,

Mark.
--
 ,-_|\
/  .  \   Mark Lawrence
\_,-._/   nomad@null.net
     v


В списке pgsql-general по дате отправления:

Предыдущее
От: borchert@antsatwork.de (Konstantin Borchert)
Дата:
Сообщение: Re: Problem with postgreSQL (number of backends)
Следующее
От: Ryan Mahoney
Дата:
Сообщение: Re: IBM to buy Informix