Search Postgresql Archives

Re: Restarting DB after moving to another drive

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

 



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