I just get it back running with the old drive - was some Windows hidden
behavior! 

However, does someone could tell me what went wrong with the procedure I
used to move the DB? 
And/or what procedure I should have used in order to get it right?

Daniel

-----Original Message-----
From: Raymond O'Donnell [mailto:r...@iol.ie] 
Sent: May-11-15 07:50
To: Daniel Begin; pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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
r...@iol.ie



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to