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 5A491D1B51D for ; Fri, 19 Sep 2003 13:59:24 +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 45297-06 for ; Fri, 19 Sep 2003 10:58:55 -0300 (ADT) Received: from localhost.localdomain (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id F1DC5D1B502 for ; Fri, 19 Sep 2003 10:58:51 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h8JCoUqd015251; Fri, 19 Sep 2003 08:50:30 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h8JDwcZ15688; Fri, 19 Sep 2003 09:58:38 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id TD8AS8PP; Fri, 19 Sep 2003 09:58:36 -0400 Subject: Re: initdb problem From: Robert Treat To: Jaskier Cc: pgsql-admin@postgresql.org, Andy Callan In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 19 Sep 2003 09:58:37 -0400 Message-Id: <1063979918.25694.1668.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/316 X-Sequence-Number: 10404 On Thu, 2003-09-18 at 09:25, Jaskier wrote: > Hi, > > No it will not work, You have to be owner, or have full access to this > directory. Also you should, I think this is necessary to run Initdb as a > Postgres user. It can't be run as root, but it can be run as any other user. The key is that whichever user runs initdb will be the "master user" of the database and must own your $PGDATA directory. > > This is what you have to do: > > As root change rights to this /usr/local/pgsql and change the owner (it > would be better) to Postgres > Then do exactly the same what you have already tried to do, but as a > Postgres User > > Should Work > > Regards > > Andrzej Schulz > Galileo Selidor > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Andy Callan > Sent: Thursday, September 18, 2003 11:02 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] initdb problem > > 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, it will try but often fail if /usr/local/pgsql is owned by root. usually you have to create the /data directory and then chown it to whomever you want to run initdb. > 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. > http://www.postgresql.org/docs/7.3/interactive/creating-cluster.html Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL