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 32BA09FB477 for ; Fri, 1 Sep 2006 04:24:40 -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 81940-04-4 for ; Fri, 1 Sep 2006 07:24:15 +0000 (UTC) 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 E3B349FB46D for ; Fri, 1 Sep 2006 04:22:31 -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 9EECD5AF8C1 for ; Fri, 1 Sep 2006 07:22:30 +0000 (GMT) Received: from [192.168.0.152] ([85.160.11.54]) by mail.mimolimit.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.1830); Fri, 1 Sep 2006 09:22:26 +0200 Message-ID: <44F7DFA5.2060409@maylo.cz> Date: Fri, 01 Sep 2006 09:22:13 +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 References: <44F6FA9D.7070509@maylo.cz> <8413.1157039623@sss.pgh.pa.us> In-Reply-To: <8413.1157039623@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 01 Sep 2006 07:22:27.0076 (UTC) FILETIME=[6094D440:01C6CD97] 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/1 X-Sequence-Number: 22915 Tom Lane wrote: >"Josef J. Micka" writes: > > >>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 >> >> > >Try "su - postgres" ... plain su retains root's environment. > > regards, tom lane > > thanks, that works i'm using su only sometimes, and don't know about this apearance. (never had problems with "su" becausy mostly i'm running it from non-privileged user, but because user postgres has no password and no shell, i must do that from root this time) so thanks again. regards, Josef