X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1E9159FB72D for ; Fri, 1 Sep 2006 13:35:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 05237-03-2 for ; Fri, 1 Sep 2006 13:33:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 4B0049FB721 for ; Fri, 1 Sep 2006 12:14:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.mimolimit.com (15-153-99-82.zizkov.angel.static.bluetone.cz [82.99.153.15]) by svr4.postgresql.org (Postfix) with ESMTP id 1D7965AF88E for ; Fri, 1 Sep 2006 15:14:46 +0000 (GMT) Received: from [192.168.0.199] ([88.102.108.58]) by mail.mimolimit.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.1830); Fri, 1 Sep 2006 17:14:35 +0200 Message-ID: <44F84E51.7090201@maylo.cz> Date: Fri, 01 Sep 2006 17:14:25 +0200 From: "Josef J. Micka" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.13) Gecko/20060414 X-Accept-Language: en, cs MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: problem with initlocation Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 01 Sep 2006 15:14:35.0750 (UTC) FILETIME=[55C97060:01C6CDD9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/7 X-Sequence-Number: 22921 Joshua D. Drake wrote: > Scott Marlowe wrote: > >> 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? > > > > I think a more appropriate question would be why is he running a > version of PostgreSQL that still has initlocation? > > Sincerely, > > Joshua D. Drake > > >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 5: don't forget to increase your free space map settings >> > because it's latest stable version for debian sarge. and i rather use possibly "older but stable" software, then "unstable" or "development" software on production server. also i don't need features of new version, in fact, i may stay on 6.5, but from my point of view is 7.4 faster, and as i said, it's "stable" for debian. regards Josef J. Micka