Re: Moving PostgreSQL data directory on Windows

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(at)sollentuna(dot)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 using regedit. Go to
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql-8.1
>
> Open the value "ImagePath" and change the data directory.
>
> //Magnus
>