Re: How to I relocate the Postgresql data directory - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: How to I relocate the Postgresql data directory
Date
Msg-id i8jnj7$8bh$1@dough.gmane.org
Whole thread Raw
In response to How to I relocate the Postgresql data directory  ("Vorpal" <vorpalswordsman@shaw.ca>)
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Missing uuid_generate_v1()
Next
From: Timon
Date:
Subject: Re: stuck spinlock detected at dynahash.c