Search Postgresql Archives

Re: Move PGdata to a different drive

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

 



On 2009-06-05, David Fetter <david@xxxxxxxxxx> 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.

linux (2.4 and later) can mount paths using --bind

That is, you can use mount like a symlink (except unlike a symlink the mounted
directories are still there after chroot)






>
> Cheers,
> David.
> -- 
> David Fetter <david@xxxxxxxxxx> http://fetter.org/
> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
> Skype: davidfetter      XMPP: david.fetter@xxxxxxxxx
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>


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