From: Russell Davie <rjrd@exemail.com.au>
To: pgsql-admin@postgresql.org
Subject: Re: Error: Could not change user id
Date: Mon, 29 May 2006 15:45:31 +1000
Message-ID: <20060529154531.398578e0@localhost.localdomain> (raw)
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>
On Mon, 29 May 2006 14:57:15 +1000
Tim Allen <tim@proximity.com.au> wrote:
> Russell Davie wrote:
> > On Sun, 28 May 2006 20:59:33 -0400 Tom Lane <tgl@sss.pgh.pa.us>
> > 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! <doh>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: rjrd@exemail.com.au
Subject: Re: Error: Could not change user id
In-Reply-To: <20060529154531.398578e0@localhost.localdomain>
References: <20060529093122.79854750@localhost.localdomain> <1271.1148864373@sss.pgh.pa.us> <20060529142515.2da47049@localhost.localdomain> <447A7F2B.9010704@proximity.com.au> <20060529154531.398578e0@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox