Re: Moving PostgreSQL data directory on Windows

Поиск
Список
Период
Сортировка
От Ottó Havasvölgyi
Тема Re: Moving PostgreSQL data directory on Windows
Дата
Msg-id 34608c0c0601131721u4588e470p@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Moving PostgreSQL data directory on Windows  ("Magnus Hagander" <mha@sollentuna.net>)
Ответы Re: Moving PostgreSQL data directory on Windows  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
Список pgsql-general
Magnus,

It's a service, and it is 8.0.6. I have fixed the registry to this
value: "C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe" runservice -N
"pgsql-8.0" -D "E:\PostgreSQL\data\"

The service does not start.
This new directory definetely exists. But now there is no Event log
entry about the error. The log file says nothing because it is in the
data/pg_log directory.

Thanks,
Otto



2006/1/13, Magnus Hagander <mha@sollentuna.net>:
> > Hello,
> >
> > I would like to move the data directory to another location.
> > I have done this:
> > 1. Stop PostgreSQL
> > 2. Move data directory
> > 3. Create a PGDATA env. variable to the new location 4. Start
> > PostgreSQL
> >
> > And it cannot start, because it cannot find postgresql.conf.
> > (in Event log) What should I do now?
>
> Are you running it as a service:? If so you need to reconfigure the service. Unfortunatly,the only way to do this is
usingregedit. Go to 
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql-8.1
>
> Open the value "ImagePath" and change the data directory.
>
> //Magnus
>

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Unable to connect to a dabase
Следующее
От: Brendan Duddridge
Дата:
Сообщение: Re: Plans for 8.2?