Re: How to I relocate the Postgresql data directory

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: How to I relocate the Postgresql data directory
Дата
Msg-id i8jnj7$8bh$1@dough.gmane.org
обсуждение исходный текст
Ответ на How to I relocate the Postgresql data directory  ("Vorpal" <vorpalswordsman@shaw.ca>)
Список pgsql-general
Vorpal, 07.10.2010 02:53:
>
> PostgreSQL was installed as part of other software.
> The data folder is a subfolder of D:\Program Files\
> Specifically:
> "D:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N
> "pgsql-8.3" -D "D:\Program Files\PostgreSQL\8.3\data\"
>
> For various reasons I would like the data directory to be:
> G:\PostgreSQL\8.3\data\"
>
> I created this directory, and changed the line in the service startup,
> however the service threw an error on startup.
>
> What is the correct procedure for re-positioning the data directory.
>

Did you make sure the Postgres Windows user (which is starting the service) has "full access" to the new directory?

Regards
Thomas

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Missing uuid_generate_v1()
Следующее
От: Timon
Дата:
Сообщение: Re: stuck spinlock detected at dynahash.c