Re: Restarting DB after moving to another drive - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Restarting DB after moving to another drive
Date
Msg-id 5550974F.8090406@iol.ie
Whole thread Raw
In response to Restarting DB after moving to another drive  (Daniel Begin <jfd553@hotmail.com>)
Responses Re: Restarting DB after moving to another drive  (Daniel Begin <jfd553@hotmail.com>)
List pgsql-general
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@iol.ie


pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: noobie join question
Next
From: Daniel Begin
Date:
Subject: Re: Restarting DB after moving to another drive