[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
|
| Список | 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 по дате отправления: