X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 298C09FA32D for ; Sun, 28 May 2006 21:59:45 -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 96804-07 for ; Sun, 28 May 2006 21:59:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 6AF8D9FA131 for ; Sun, 28 May 2006 21:59:39 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k4T0xXrC001272; Sun, 28 May 2006 20:59:33 -0400 (EDT) To: Russell Davie cc: pgsql-admin@postgresql.org Subject: Re: Error: Could not change user id In-reply-to: <20060529093122.79854750@localhost.localdomain> References: <20060529093122.79854750@localhost.localdomain> Comments: In-reply-to Russell Davie message dated "Mon, 29 May 2006 09:31:22 +1000" Date: Sun, 28 May 2006 20:59:33 -0400 Message-ID: <1271.1148864373@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/388 X-Sequence-Number: 21920 Russell Davie writes: > Manually starting postgresql by the user postgres: > postgres@XXXX:/etc/init.d$ ./postgresql-7.4 start > chmod: changing permissions of `/var/run/postgresql': Operation not permitted > * Starting PostgreSQL 7.4 database server:main > Error: Could not change user id [fail] There is no such error message anywhere in the PG 7.4 source code. I suppose it's coming out of whatever init script you're using; have you tried reading the init script for enlightenment? (FWIW, init scripts are almost always designed to be executed as root, not as random unprivileged users like postgres. sudo might help.) regards, tom lane