Skip site navigation (1) Skip section navigation (2)

BUG #4706: Cannot change data directory path

From: "Norbert Neubauer" <norbertn(at)post(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4706: Cannot change data directory path
Date: 2009-03-15 13:22:10
Message-ID: 200903151322.n2FDMA61093729@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4706
Logged by:          Norbert Neubauer
Email address:      norbertn(at)post(dot)pl
PostgreSQL version: 8.3.6-2
Operating system:   Windows XP PRO
Description:        Cannot change data directory path
Details: 

Today I reinstalled my computer I use for software development. I installed
latest PostgreSQL for windows (from postgresql-8.3.6-2.zip). I decided that
I want to move postgresql data folder to different drive than C.

What I found.
1. I can change data folder during postgres install, but if D drive was
chosen, the postgres would not start

2. Installed with default settings and when I used installer to modify the
installation settings (in order to change the data directory location) the
setup failed with the following error:
"The installer has encountered an unexpected error ... the error code is
2864".

3. If I change the data folder location to d: via regedit and want to start
postgres I got the following error in event viewer:

2009-03-15 13:08:21 GMT FATAL:  data directory "D:/PGSQLData" does not
exist

And I tried all the combinations I could think of, which is:
d:\PGSQLData\
d:\\PGSQLData\\
d:\PGSQLData
d:\\PGSQLData

d:/PGSQLData/
d:/PGSQLData

None of them worked.

Brgs
Norbert

pgsql-bugs by date

Next:From: Disha NayakDate: 2009-03-16 06:29:10
Subject: BUG #4707: Alter Constraint
Previous:From: Sergey BurladyanDate: 2009-03-15 04:17:50
Subject: Re: BUG #4705: Software developer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group