X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 11F8BDBDE6 for ; Sun, 27 Nov 2005 00:43:11 -0400 (AST) 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 71804-07 for ; Sun, 27 Nov 2005 04:43:09 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 96530DBDC5 for ; Sun, 27 Nov 2005 00:43:08 -0400 (AST) Received: from fuse6.mailanyone.net (fuse6.mailanyone.net [69.31.1.175]) by svr2.postgresql.org (Postfix) with ESMTP id BC106F0B6C for ; Sun, 27 Nov 2005 04:43:07 +0000 (GMT) Received: from mailanyone.net by fuse6.mailanyone.net with asmtp (TLSv1:AES256-SHA:256) (MailAnyone extSMTP) id 1EgENa-0002qj-ID for pgsql-admin@postgresql.org; Sat, 26 Nov 2005 22:43:10 -0600 Message-ID: <4389394F.8080205@tgharold.com> Date: Sat, 26 Nov 2005 23:42:55 -0500 From: Thomas Harold User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.11) Gecko/20050728 X-Accept-Language: en-us, en, ja, zh-cn, zh-hk, zh-sg, zh-tw, ko, ko-kp, ko-kr MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: Problems when initdb on WinXP with SP2. References: <1f55ed4c0511240202l742ecd41ofe568cafae80b995@mail.gmail.com> In-Reply-To: <1f55ed4c0511240202l742ecd41ofe568cafae80b995@mail.gmail.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.428 required=5 tests=[AWL=0.239, MISSING_HEADERS=0.189, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.428 X-Spam-Level: X-Archive-Number: 200511/318 X-Sequence-Number: 19691 Johnson Zhao wrote: > Hi, > > I use Postgresql 8.03/ 8.04 on windows xp with sp2, all have same problems. > > run the windows cmd by: > > runas /user:postgres cmd > > and run the initdb program like: > > initdb --locale=C --username=postgres -W -A md5 -E UNICODE -D ../data > > then it says: > > creating directory ../data/ ... ok > creating directory ../data/global ... ok > creating directory ../data/pg_xlog ... ok > creating directory ../data/pg_xlog/archive_status ... ok > creating directory ../data/pg_clog ... ok > creating directory ../data/pg_subtrans ... ok > creating directory ../data/base ... ok > creating directory ../data/base/1 ... ok > creating directory ../data/pg_tblspc ... ok > selecting default max_connections .... > > and the command window stayed there! I have no idea whether this matters or not, but I got bit during an 8.1 install by permissions issues. The postgres user requires read/write permissions for the data folder and below, but it also requires read permissions all the way back to the root of the drive (including the root directory). The specific situation for us was that we were trying to install to D:\PostgreSQL\Data, but the postgres user didn't have read permissions on the root of D:\ (or D:\PostgreSQL).