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 9A64C9FB3C9 for ; Thu, 31 Aug 2006 12:39:22 -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 04446-01-8 for ; Thu, 31 Aug 2006 12:39:16 -0300 (ADT) X-Greylist: delayed 00:31:20.31802 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 20F239FB402 for ; Thu, 31 Aug 2006 12:36:34 -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 53F0D5AF041 for ; Thu, 31 Aug 2006 15:05:13 +0000 (GMT) Received: from [10.0.100.61] ([82.99.153.15]) by mail.mimolimit.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.1830); Thu, 31 Aug 2006 17:05:09 +0200 Message-ID: <44F6FA9D.7070509@maylo.cz> Date: Thu, 31 Aug 2006 17:05:01 +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: problem with initlocation Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 31 Aug 2006 15:05:09.0278 (UTC) FILETIME=[D9BAEBE0:01C6CD0E] 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: 200608/348 X-Sequence-Number: 22891 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 Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process. postgres@www:/home/db/postgres$ postgres server runs under user postgres postgres@www:/home/web/holandsko# ps uxaw |grep post postgres 11006 0.0 0.0 17088 1292 ? S Jun29 7:16 /usr/lib/postgresql/bin/postmaster -D /var/lib/postgres/data postgres 11012 0.0 0.1 7888 2668 ? S Jun29 11:22 postgres: stats buffer process postgres 11013 0.0 0.1 7944 2500 ? S Jun29 10:09 postgres: stats collector process postgres 11029 0.0 0.1 12780 3116 ? Ss Jun29 17:58 /usr/lib/postgresql/bin/pg_autovacuum -D -p 5432 -L /var/log/postgresql/autovacuum_log and info about system Debian Sarge, kernel 2.4.32, postgresql version 7.4.7 thanks Josef Micka