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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Restore database from files (not dump files)?
Дата
Msg-id 200612011732.kB1HWUk19778@momjian.us
обсуждение исходный текст
Ответ на Restore database from files (not dump files)?  (wheel <wheel@wheel.not>)
Список pgsql-general
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.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: "Alejandro Michelin Salomon \( Adinet \)"
Дата:
Сообщение: RES: Problem with function parameters
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: transfer just the data directories from linux to windows?