Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 0B54F1337B95 for ; Thu, 23 Dec 2010 18:35:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 58289-02 for ; Thu, 23 Dec 2010 22:35:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id A92F113364DE for ; Thu, 23 Dec 2010 18:35:31 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id oBNMZVRA029128; Thu, 23 Dec 2010 17:35:31 -0500 (EST) To: nbald cc: pgsql-admin@postgresql.org Subject: Re: "root" execution not permitted. and busybox In-reply-to: <1293141830332-3317041.post@n5.nabble.com> References: <1293141830332-3317041.post@n5.nabble.com> Comments: In-reply-to nbald message dated "Thu, 23 Dec 2010 14:03:50 -0800" Date: Thu, 23 Dec 2010 17:35:31 -0500 Message-ID: <29127.1293143731@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/178 X-Sequence-Number: 36407 nbald writes: > this is driving me crazy... Do someone have an idea ? > # echo 'pgsql:pgsql:100:100:pgsql:/home/pgsql:/bin/sh' >> /etc/passwd That might have been the only way to create a Unix user account back around 1972, but it hardly seems like the recommended way now. Doesn't your distro provide a tool for that? > # su - pgsql > warning: cannot change to home directory > BusyBox v1.7.2 (2010-12-23 22:00:59 CET) built-in shell (ash) > Enter 'help' for a list of built-in commands. > $ /tmp/mnt/usb0/part1/usr/bin/postmaster -D '/tmp/mnt/usb0/part1/caisse/db' > "root" execution of the PostgreSQL server is not permitted. It sure looks to me like you got the account creation wrong somehow. Possibly running "id" here would shed some light on what login state the postmaster is seeing. regards, tom lane