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 B58DC9FA2FA for ; Mon, 29 May 2006 02:45:47 -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 37028-02 for ; Mon, 29 May 2006 02:45:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from jay.exetel.com.au (jay.exetel.com.au [220.233.0.8]) by postgresql.org (Postfix) with ESMTP id 80E859FA380 for ; Mon, 29 May 2006 02:45:33 -0300 (ADT) Received: (qmail 30092 invoked by uid 507); 29 May 2006 15:45:32 +1000 Received: from 19.20.233.220.exetel.com.au (HELO localhost.localdomain) (220.233.20.19) by jay.exetel.com.au with SMTP; 29 May 2006 15:45:32 +1000 Date: Mon, 29 May 2006 15:45:31 +1000 From: Russell Davie To: pgsql-admin@postgresql.org Subject: Re: Error: Could not change user id Message-ID: <20060529154531.398578e0@localhost.localdomain> In-Reply-To: <447A7F2B.9010704@proximity.com.au> References: <20060529093122.79854750@localhost.localdomain> <1271.1148864373@sss.pgh.pa.us> <20060529142515.2da47049@localhost.localdomain> <447A7F2B.9010704@proximity.com.au> X-Mailer: Sylpheed-Claws 2.1.1 (GTK+ 2.8.6; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/391 X-Sequence-Number: 21923 On Mon, 29 May 2006 14:57:15 +1000 Tim Allen wrote: > Russell Davie wrote: > > On Sun, 28 May 2006 20:59:33 -0400 Tom Lane > > wrote: > >> 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? > > > Interesting! I never thought it could be the window manager. This is > > still occurring using Metacity and it still happened in Enlightnement > > and WindowMaker and also at CLI without any window-manager at all! > > I'm quite sure that Tom was referring to enlightenment in the general > sense of the word, ie some init script (eg the one for the postgresql > service) might enlighten you as to what is going on! :-) thanks for that! I *was* wondering what he meant and found the error message in start-up script /usr/share/postgresql-common/PgCommon.pm Reading the script suggests that the user to be a member of the "shadow" group, which is now done. However, postgresql is still not starting and produces the same errors: postgres@XXXXX:~$ /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] Are there special privileges that the "shadow" group has? What is eluding me is decyphering it into practical steps to getting postgresql working again. TIA Rusell > > Tim > > -- > ----------------------------------------------- > Tim Allen tim@proximity.com.au > Proximity Pty Ltd http://www.proximity.com.au/ > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly