X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id CC25B9FB3E4 for ; Thu, 31 Aug 2006 13:03:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 67506-05-3 for ; Thu, 31 Aug 2006 16:03:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 3B5F79FB409 for ; Thu, 31 Aug 2006 13:02:56 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 31 Aug 2006 16:02:54 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 31 Aug 2006 11:02:54 -0500 Subject: Re: problem with initlocation From: Scott Marlowe To: "Josef J. Micka" Cc: pgsql-admin@postgresql.org In-Reply-To: <44F6FA9D.7070509@maylo.cz> References: <44F6FA9D.7070509@maylo.cz> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1157040174.10490.53.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 31 Aug 2006 11:02:54 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200608/350 X-Sequence-Number: 22893 On Thu, 2006-08-31 at 10:05, Josef J. Micka wrote: > i want to make database in another place and i'm unable to use > initlocation, and i don't know, what i'm doing wrong. > > this is what i do, and i think it's correct. > > www:/home/db/postgres$ su postgres > postgres@www:/home/db/postgres$ ls -l > total 12 > drwx------ 6 postgres postgres 4096 Aug 31 14:59 data > drwxr-xr-x 2 postgres postgres 4096 Aug 31 14:19 data-web > drwx------ 3 postgres postgres 4096 Oct 15 2004 dumpall > postgres@www:/home/db/postgres$ /usr/lib/postgresql/bin/initlocation > /home/db/postgres/data-web/ > initlocation: cannot be run as root What does the command whoami say right before you would run the initlocation?