Re: How to I relocate the Postgresql data directory

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to I relocate the Postgresql data directory
Date: 2010-10-07 05:59:04
Message-ID: i8jnj7$8bh$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Timon 2010-10-07 06:09:57 Re: stuck spinlock detected at dynahash.c
Previous Message Magnus Hagander 2010-10-07 05:47:55 Re: Missing uuid_generate_v1()