Re: Move PGdata to a different drive

Поиск
Список
Период
Сортировка
От Yaroslav Tykhiy
Тема Re: Move PGdata to a different drive
Дата
Msg-id 4A2DCB0D.9030603@barnet.com.au
обсуждение исходный текст
Ответ на Re: Move PGdata to a different drive  (David Fetter <david@fetter.org>)
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Why lots of temp schemas are being created
Следующее
От: Lizzy M
Дата:
Сообщение: Can postgresql store its data on raw device now?