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 78E61D1B4E2 for ; Sat, 20 Sep 2003 22:51:17 +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 44697-01 for ; Sat, 20 Sep 2003 19:50:47 -0300 (ADT) Received: from smtp3.poczta.onet.pl (smtp3.poczta.onet.pl [213.180.130.29]) by svr1.postgresql.org (Postfix) with ESMTP id E9A52D1B8B7 for ; Sat, 20 Sep 2003 19:50:45 -0300 (ADT) Received: from pa109.kamienna-gora.sdi.tpnet.pl ([212.160.17.109]:7684 "HELO jaskier") by ps3.test.onet.pl with SMTP id ; Sun, 21 Sep 2003 00:42:23 +0200 Message-ID: <003201c37fc8$87098280$0300a8c0@jaskier> From: "Andrzej Schulz" To: References: <1063979918.25694.1668.camel@camel> Subject: Re: initdb problem Date: Sun, 21 Sep 2003 00:42:41 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/332 X-Sequence-Number: 10420 Yeah, and that is that i hda in mind. Problem is that almost always it is postgres user, cause it is recommended. Due to protection reasons, some kind :-). Andrzej Schulz Galileo Selidor ----- Original Message ----- From: "Robert Treat" To: "Jaskier" Cc: ; "Andy Callan" Sent: Friday, September 19, 2003 3:58 PM Subject: Re: [ADMIN] initdb problem > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings