Обсуждение: initdb failing

Hi all,

I am using PostgreSQL 8.4.1 on Windows XP SP3 (64 -bit).

This is what i get when i fire initdb command:

D:\Base\NetScope\pg\bin>initdb.exe -d -n -U postgres -D d:\base\netscope\pg\data

Running in debug mode.
Running in noclean mode. Mistakes will not be cleaned up.
Running in debug mode.
Running in noclean mode. Mistakes will not be cleaned up.
VERSION=8.4.1
PGDATA=d:/base/netscope/pg/data
share_path=D:/Base/NetScope/pg/share
PGPATH=D:/Base/NetScope/pg/bin
POSTGRES_SUPERUSERNAME=postgres
POSTGRES_BKI=D:/Base/NetScope/pg/share/postgres.bki
POSTGRES_DESCR=D:/Base/NetScope/pg/share/postgres.description
POSTGRES_SHDESCR=D:/Base/NetScope/pg/share/postgres.shdescription
POSTGRESQL_CONF_SAMPLE=D:/Base/NetScope/pg/share/postgresql.conf.sample
PG_HBA_SAMPLE=D:/Base/NetScope/pg/share/pg_hba.conf.sample
PG_IDENT_SAMPLE=D:/Base/NetScope/pg/share/pg_ident.conf.sample
The files belonging to this database system will be owned by user "NetScopeAdmin ".
This user must also own the server process.

The database cluster will be initialized with locale Portuguese_Portugal.1252.
The default database encoding has accordingly been set to WIN1252.
The default text search configuration will be set to "portuguese".

fixing permissions on existing directory d:/base/netscope/pg/data ... ok
creating subdirectories ... initdb: could not create directory "d:/base/netscope/pg": File exists
initdb: data directory "d:/base/netscope/pg/data" not removed at user's request




Anything that i am missing anywhere?? 

-- 
Regards,
Sachin Srivastava
www.enterprisedb.com

On 06/10/2009 19:00, Sachin Srivastava wrote:

> fixing permissions on existing directory d:/base/netscope/pg/data ... ok
> * creating subdirectories ... initdb: could not create directory
> "d:/base/netscope/pg": File exists
> *initdb: data directory "d:/base/netscope/pg/data" not removed at user's
> request

Could it be that the "..../data" directory isn't empty? I think initdb
will fail if this is the case.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

On 10/06/2009 11:41 PM, Raymond O'Donnell wrote:
> On 06/10/2009 19:00, Sachin Srivastava wrote:
>
>
>> fixing permissions on existing directory d:/base/netscope/pg/data ... ok
>> * creating subdirectories ... initdb: could not create directory
>> "d:/base/netscope/pg": File exists
>> *initdb: data directory "d:/base/netscope/pg/data" not removed at user's
>> request
>>
> Could it be that the "..../data" directory isn't empty? I think initdb
> will fail if this is the case.
>
its empty or i say its newly created.
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>


--
Regards,
Sachin Srivastava
www.enterprisedb.com

On 10/07/2009 01:24 AM, Scott Mead wrote:

On Tue, Oct 6, 2009 at 3:09 PM, Sachin Srivastava <sachin.srivastava@enterprisedb.com> wrote:

On 10/06/2009 11:41 PM, Raymond O'Donnell wrote:

On 06/10/2009 19:00, Sachin Srivastava wrote:

 

fixing permissions on existing directory d:/base/netscope/pg/data ... ok
* creating subdirectories ... initdb: could not create directory
"d:/base/netscope/pg": File exists
*initdb: data directory "d:/base/netscope/pg/data" not removed at user's
request
   

Could it be that the "..../data" directory isn't empty? I think initdb
will fail if this is the case.
 

its empty or i say its newly created.

  Because you're using the -n flag, after you run initdb once, the directory is left there.  Delete the 'data' directory and try again.

Actually i put the -n and -d flags just to get more information about what all has been created but they remain empty. Nevertheless tried removing the old data directory and without -n option still got the same output.

--Scott

-- 
Regards,
Sachin Srivastava
www.enterprisedb.com