Rebuilding database from table files
От | Mark Lawrence |
---|---|
Тема | Rebuilding database from table files |
Дата | |
Msg-id | Pine.LNX.4.21.0104301443250.14357-100000@null обсуждение исходный текст |
Ответ на | [QUESTION]: Recovery of tables (Mark Lawrence <nomad@null.net>) |
Ответы |
Re: Rebuilding database from table files
|
Список | pgsql-general |
Help! Is it possible to rebuild a database when you only have the files that contain the table data? There was no response when I posted this before. Does this mean that there is no solution? Mark. -- ,-_|\ / . \ Mark Lawrence \_,-._/ nomad@null.net v On Wed, 25 Apr 2001, Mark Lawrence wrote: > 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 по дате отправления: