Re: Restarting DB after moving to another drive

Thank for the link!

Just to make sure I understand properly...
When I installed Postgresql, I set $PGDATA to point on my old drive and I
must now move everything on the new one.

In order to move everything on the new drive I must create a tablespace on
the new drive and then explicitly define this tablespace as the new location
of...

- the postgres database
- my personal database
- pg_default
- pg_global

Anything I missed or put in the wrong sequence?

Regards,
Daniel

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Raymond O'Donnell
Sent: May-11-15 09:19
To: Daniel Begin; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Restarting DB after moving to another drive

On 11/05/2015 13:38, Daniel Begin wrote:
> 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?

I've never done it myself, but I understand that one way to do it is with
tablespaces:

http://www.postgresql.org/docs/9.4/static/manage-ag-tablespaces.html

As I understand it, you create a new tablespace on the new disk, then move
your database objects to it.

How that plays with Windows, I've no idea.... I'd guess that changing the
drive letter might well cause Bad Things to happen.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

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