Re: Move PGdata to a different drive - Mailing list pgsql-general

From Yaroslav Tykhiy
Subject Re: Move PGdata to a different drive
Date
Msg-id 4A2DCB0D.9030603@barnet.com.au
Whole thread Raw
In response to Re: Move PGdata to a different drive  (David Fetter <david@fetter.org>)
List pgsql-general
David Fetter wrote:
> On Thu, Jun 04, 2009 at 11:11:29AM -0400, Bruce Momjian wrote:
>> Jennifer Trey wrote:
>>> Hi,
>>> What file should I be working with?
>> Just shut down the server and move the directory whever you want and
>> restart the server.  There are no file contents that need changing.
>> Of course should adjust your scripts or PGDATA environment variable.
>
> Another way to do this is to mount the drive at the place where PGDATA
> used to be.  The down side of this approach is that it only works if
> you want your PGDATA at the root of that new drive.

And of course one can create a safety symlink to the new location of
PGDATA from the old location just in case, e.g., if one suspects
hidden references to PGDATA location in home-made scripts etc.  Of
course, that had better be straightened out sooner than later and the
safety symlink removed for the sake of clarity, but when you need to
get everything rolling *ASAP*, temporary symlinks can be helpful.

Yar

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Why lots of temp schemas are being created
Next
From: Lizzy M
Date:
Subject: Can postgresql store its data on raw device now?