Re: initdb failure on Windows XP

On Fri, 2009-07-17 at 23:42 +0530, Sachin Srivastava wrote:
> I am using PostgreSQL 8.3 on Windows XP SP2.
>
> I am getting this strange error while initdb:
>
> Part of the error message i get,
>
> The database cluster will be initialized with locale English_United
> States.1252.
>
> The default database encoding has accordingly been set to WIN1252.
> The default text search configuration will be set to "english".
>
> fixing permissions on existing directory C:/postgres/data ... ok
> creating subdirectories ... initdb: could not create directory
> "C:/postgres": File exists
> initdb: removing contents of data directory "C:/postgres/data"
>
>
> Looking into the initdb code, it should create sub directories (global,
> pg_xlog, pg_clog, base etc ) under directory C:/postgres/data. I cannot
> understand, why it is trying to create "C:/postgres".
>
> Any thoughts?

Well the error I see is that C:/postgres already exists. Meaning you had
a postgres file or directory already. Initdb will bail out if that is
the case.

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997