Search Postgresql Archives

Re: Restarting DB after moving to another drive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:rod@xxxxxx] 
Sent: May-11-15 07:50
To: Daniel Begin; pgsql-general@xxxxxxxxxxxxxx
Subject: 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@xxxxxx



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux