Re: Move PGdata to a different drive

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Move PGdata to a different drive
Дата
Msg-id 20090605143558.GB5929@fetter.org
обсуждение исходный текст
Ответ на Re: Move PGdata to a different drive  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Move PGdata to a different drive  (Yaroslav Tykhiy <yar@barnet.com.au>)
Список pgsql-general
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.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: invalid byte sequence for encoding "UTF8": 0xab
Следующее
От: "Anirban Pal"
Дата:
Сообщение: How to know the indexes on a Table