Restore "data/base/myDB/" raw data files

Поиск

Список

Период

Сортировка

От	Jeff Ward
Тема	Restore "data/base/myDB/" raw data files
Дата	18 июля 2003 г. 14:44:34
Msg-id	000b01c34d54$4dcb5a30$6401a8c0@brainhum.com обсуждение
Список	pgsql-admin

Дерево обсуждения

So I have a "data/base/myDB/" directory with a database that I need to restore from Postgres 7.0.2 on a Cobalt RaQ4 that went down. All I have is the directory to work with, and I see these files that I need are in there. I opened up one of the table files with a text editor and I could see all the data but there was lots of garbled stuff around it. So, .... sigh of relief that the data is in there .... but how can I get it out?

Having troubles restoring the data as I learn how to do this. I copied this /myDB/ to my new /base/ directory and hoped it'd all just work. Of course, when I try to connect to that database, it can't find the database. So, I created a database with the same name as the one i need to restore. Then, I copied the table files from the /base/ backup, hoping that the tables would just show up with all my data. Nada. And I looked at the COPY command and no luck. Can somebody help me?

Jeff Ward

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Restore "data/base/myDB/" raw data files