X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 59812533B0 for ; Wed, 23 Mar 2005 14:45:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98092-10 for ; Wed, 23 Mar 2005 14:45:00 +0000 (GMT) Received: from postfix4-1.free.fr (postfix4-1.free.fr [213.228.0.62]) by svr1.postgresql.org (Postfix) with ESMTP id CC7405336B for ; Wed, 23 Mar 2005 14:44:58 +0000 (GMT) Received: from [82.225.31.50] (stbarthelemy-4-82-225-31-50.fbx.proxad.net [82.225.31.50]) by postfix4-1.free.fr (Postfix) with ESMTP id 74B3F2BC949 for ; Wed, 23 Mar 2005 15:45:02 +0100 (CET) Message-ID: <424180F7.60707@free.fr> Date: Wed, 23 Mar 2005 15:45:11 +0100 From: Olivier Martineau User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: fr, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Probllem with initdb on Windows XP Content-Type: multipart/alternative; boundary="------------000903080900080405010607" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.55 tagged_above=0 required=5 tests=AWL, HTML_20_30, HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: X-Archive-Number: 200503/367 X-Sequence-Number: 16865 This is a multi-part message in MIME format. --------------000903080900080405010607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit In fact, I was not using an administrative user but a user with special rights. I tried with a simple user and the initdb runned correctly. Thanks a lot ! --------------------------------- Well, my French isn't as good as I'd like :) but it looks as though you're trying to set up the database as an administrator. As this creates various security risks, it's not allowed. You probably created a user account during PostgreSQL installation. If you run initdb as that user, you should be OK. One handy tip, you can get a command prompt as another user without logging out of your main account, using the 'runas' command. Type runas /? for more information. Hello, I have just installed PostgreSQL (postgresql-8.0.1.zip) on a Windows XP (SP1) platform. After the installation I runned the following command : initdb -D D:\Bureautique\PostgreSQL\8.0\bin\Data but an error occured at the end of the execution. Here is the message : Les fichiers appartenant Ó ce systÞme de bases de donnÚes doivent appartenir Ó l 'utilisateur ½Administrateur+. Cet utilisateur doit aussi possÚder le processus serveur. Le groupe de bases de donnÚes sera initialisÚ avec la locale French_France.1252. crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data ... ok crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/global... ok crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_xlog... ok crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_xlog/archive_st atus... ok crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_clog... ok crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_subtrans... ok crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/base... ok crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/base/1... ok crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_tblspc... ok sÚlection de la valeur par dÚfaut de max_connections... 10 sÚlection de la valeur par dÚfaut de shared_buffers... 50 crÚation des fichiers de configuration... ok crÚation de la base de donnÚes template1 dans D:/Bureautique/PostgreSQL/8.0/bin/ Data/base/1... L'exÚcution du serveur PostgreSQL par un l'utilisateur dotÚ de dr oits d'administrateur n'est pas permise. Le serveur doit Ûtre lancÚ avec un utilisateur non privilÚgiÚ pour empÛcher tout problÞme de sÚcuritÚ sur le serveur. Voir la documentation pour plus d'informations sur le lancement propre du serveur. le processus fils a ÚtÚ terminÚ avec le signal 1 initdb : suppression du rÚpertoire des donnÚes ½D:/Bureautique/PostgreSQL/8.0/bi n/Data+ Is there anymone that can tell me what's going wrong ? Thanks, Olivier. --------------000903080900080405010607 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
In fact, I was not using an administrative user but a user with special rights. I tried  with a simple  user and the initdb runned correctly.

Thanks a lot !

---------------------------------


Well, my French isn't as good as I'd like :) but it looks as though you're 
trying to set up the database as an administrator. As this creates various 
security risks, it's not allowed. You probably created a user account 
during PostgreSQL installation. If you run initdb as that user, you should 
be OK.

One handy tip, you can get a command prompt as another user without 
logging out of your main account, using the 'runas' command. Type runas /? 
for more information.







Hello,

I have just installed PostgreSQL (postgresql-8.0.1.zip) on a Windows XP 
(SP1) platform.

After the installation I runned the following command :

initdb -D D:\Bureautique\PostgreSQL\8.0\bin\Data

but an error occured at the end of the execution. Here is the message :

Les fichiers appartenant Ó ce systÞme de bases de donnÚes doivent 
appartenir Ó l
'utilisateur ½Administrateur+.
Cet utilisateur doit aussi possÚder le processus serveur.
Le groupe de bases de donnÚes sera initialisÚ avec la locale 
French_France.1252.
crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data ... ok
crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/global... ok
crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_xlog... 
ok
crÚation du rÚpertoire 
D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_xlog/archive_st
atus... ok
crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_clog... 
ok
crÚation du rÚpertoire 
D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_subtrans... ok
crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/base... ok
crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/base/1... ok
crÚation du rÚpertoire D:/Bureautique/PostgreSQL/8.0/bin/Data/pg_tblspc... 
ok
sÚlection de la valeur par dÚfaut de max_connections... 10
sÚlection de la valeur par dÚfaut de shared_buffers... 50
crÚation des fichiers de configuration... ok
crÚation de la base de donnÚes template1 dans 
D:/Bureautique/PostgreSQL/8.0/bin/
Data/base/1... L'exÚcution du serveur PostgreSQL par un l'utilisateur dotÚ 
de dr
oits d'administrateur n'est pas permise.
Le serveur doit Ûtre lancÚ avec un utilisateur non privilÚgiÚ pour 
empÛcher
tout problÞme de sÚcuritÚ sur le serveur. Voir la documentation pour
plus d'informations sur le lancement propre du serveur.
le processus fils a ÚtÚ terminÚ avec le signal 1
initdb : suppression du rÚpertoire des donnÚes 
½D:/Bureautique/PostgreSQL/8.0/bi
n/Data+

Is there anymone that can tell me what's going wrong ?
Thanks,

Olivier. 
--------------000903080900080405010607--