Re: Restarting DB after moving to another drive

On 11/05/2015 12:03, Daniel Begin wrote:
> 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”

Hi there,

Sounds like you're on Windows - you can get more information from
PostgreSQL's own logs, which by default on Windows are in a directory
called pg_log under the data directory.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie