Re: Restarting DB after moving to another drive

From: Daniel Begin <jfd553(at)hotmail(dot)com>
To: <rod(at)iol(dot)ie>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restarting DB after moving to another drive
Date: 2015-05-11 12:38:44
Message-ID: COL129-DS810FEBDB18EE7DF6E1BDC94DB0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie]
Sent: May-11-15 07:50
To: Daniel Begin; pgsql-general(at)postgresql(dot)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
rod(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2015-05-11 13:06:43 Re: noobie join question
Previous Message Raymond O'Donnell 2015-05-11 11:49:35 Re: Restarting DB after moving to another drive