Restarting DB after moving to another drive

Поиск
Список
Период
Сортировка
От Daniel Begin
Тема Restarting DB after moving to another drive
Дата
Msg-id COL129-DS17F0469C7883B09499B11194DB0@phx.gbl
обсуждение исходный текст
Ответы Re: Restarting DB after moving to another drive
Список pgsql-general

I am working on windows and I had to move my database on another hard drive after the original one started overheating. In order to move the DB I did the following…

 

-Stop postgresql-x64-9.3 service – and wait until there were no more system access to on the original drive

-Copy the entire content of the original drive to the new one (the drive is dedicated to the DB)

-Turn off the original hard drive and reassign the old drive letter to the new one

-Restart the DB

 

I tried to connect to the database by using PgAdmin III and I got the following error message:

“Could not read symbolic link “pg_tblspc/100589”: Invalid argument”

 

I concluded something went wrong and I decided to get back to the old drive. I stopped the DB, turned off the new drive, turned on the old one and tried to restart the postgresql service but it does not start anymore. The only message I get is:

“Postgresql-x64-9.3 service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs”

 

I am the only user of the database

 

Hoping someone can help

Daniel

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

Предыдущее
От: Steve Clark
Дата:
Сообщение: noobie join question
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: noobie join question