Re: Restore database from files (not dump files)?

Поиск
Список
Период
Сортировка
От wheel
Тема Re: Restore database from files (not dump files)?
Дата
Msg-id MPG.1fda10e0a5d8a5e989739@newsgroups.comcast.net
обсуждение исходный текст
Ответ на Restore database from files (not dump files)?  (wheel <wheel@wheel.not>)
Ответы Re: Restore database from files (not dump files)?  (brian <brian@zijn-digital.com>)
Список pgsql-general
In article <200612011732.kB1HWUk19778@momjian.us>, bruce@momjian.us
says...
> wheel wrote:
> > Can a pgsql 8.1 database be restored from the raw file? For one database
> > I have only the files found in  the base folder, example C:\PostgreSQL
> > \data\base\16404, there are many files called 1247, 1248, etc (no
> > extension). I think these are the files that make up the database? For
> > this db I don't have a dump file, just what is on disk. I do know the
> > users and passwords etc. I've hunted around quite a bit in various
> > places and most of the restore discussions center around files created
> > with pg_dump.
>
> Uh, do you have the entier /data directory tree?  If so, just restore
> the directory start it up a binary.
>
>
Yes I have the entire dir/file set. But what does "If so, just restore
the directory start it up a binary" mean? Restore the dir, you mean copy
it to it's location under \base? What does start it up a(s?) binary
mean? I'm new to postgres.

I have copied the folders back to the base dir (like C:\PostgreSQL\data
\base\16404) if that's step one but what after that?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Concatenate performance question
Следующее
От: "Niederland"
Дата:
Сообщение: vacuum in standalone mode