Search Postgresql Archives

Re: Move PGdata to a different drive

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

 



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

--
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