X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6F2A7D1B508 for ; Thu, 18 Sep 2003 09:02:21 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 21617-07 for ; Thu, 18 Sep 2003 06:01:51 -0300 (ADT) Received: from osgood.cc.nd.edu (osgood.cc.nd.edu [129.74.250.227]) by svr1.postgresql.org (Postfix) with ESMTP id 475C3D1B4EB for ; Thu, 18 Sep 2003 06:01:49 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by osgood.cc.nd.edu (Switch-3.1.0/Switch-3.1.0) with ESMTP id h8I91fam014553 for ; Thu, 18 Sep 2003 04:01:47 -0500 (EST) Received: from sipa-gw.highway1.com.au (sipa-gw.highway1.com.au [202.61.233.34]) by webmail.nd.edu (IMP) with HTTP for ; Thu, 18 Sep 2003 04:01:41 -0500 Message-ID: <1063875701.3f6974755ccd8@webmail.nd.edu> Date: Thu, 18 Sep 2003 04:01:41 -0500 From: Andy Callan To: pgsql-admin@postgresql.org Subject: initdb problem MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 202.61.233.34 X-ND-MTA-Date: Thu, 18 Sep 2003 04:01:47 -0500 (EST) X-ND-Virus-Scan: engine v4.2.40; dat v4293 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/305 X-Sequence-Number: 10393 My installation of PostgreSQL was created when i installed a GIS application but it does not appear to have a data cluster specified so I did the following: [Computer:local/pgsql/bin] andrewcallan% ./initdb -D /usr/local/pgsql/data The files belonging to this database system will be owned by user "andrewcallan". This user must also own the server process. Fixing permissions on existing directory /usr/local/pgsql/data... chmod: /usr/local/ pgsql/data: Operation not permitted initdb failed. Also just for kicks I tried to startup to server since i don't know exactly what the auto- install did and did not do and this is what happened: [Computer:local/pgsql/bin] andrewcallan% ./postmaster -D /usr/local/pgsql/data FATAL 1: data directory /usr/local/pgsql/data has group or world access; permissions should be u=rwx (0700) --I created the /data directory just with a mkdir as the root b/c at the time i did not know if initdb would create it if it didn't exist, its my understanding initdb will change the permissions as needed so this problem should go away.... I am completely new to PostgreSQL and have spent the last couple weeks playing with installing both it and mySQL to try to link some data to the GIS application so I really do not know what am I doing and this could be a really stupid mistake, please be gentle.... Many thanks for your assistance. -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1