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 105779FA32D for ; Sun, 28 May 2006 20:38:14 -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 89370-03 for ; Sun, 28 May 2006 20:38:06 -0300 (ADT) X-Greylist: delayed 00:06:39.874986 by SQLgrey- Received: from jay.exetel.com.au (jay.exetel.com.au [220.233.0.8]) by postgresql.org (Postfix) with ESMTP id A18CD9FA131 for ; Sun, 28 May 2006 20:38:06 -0300 (ADT) Received: (qmail 26314 invoked by uid 507); 29 May 2006 09:31:22 +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 09:31:22 +1000 Date: Mon, 29 May 2006 09:31:22 +1000 From: Russell Davie To: pgsql-admin@postgresql.org Subject: Error: Could not change user id Message-ID: <20060529093122.79854750@localhost.localdomain> 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/387 X-Sequence-Number: 21919 Hi All I have used PostgreSQL for SQL-Ledger in Linux (Ubuntu) for about 6months and have run into PostgreSQL problems when it starts up. PostgreSQL is reporting errors about changing user id so that it falls over when the system boots. I've read this: http://archives.postgresql.org/pgsql-admin/2006-01/msg00273.php I have found FAQ for Linux: http://www.designmagick.com/article/2/Starting-Out/Installing-PostgreSQL yet this error still occurs after changing the permissions of the postgresql directory ie: sudo chown -R postgres:postgres /usr/share/postgresql sudo chown -R postgres:postgres /usr/share/postgresql-common what happens: 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] after changing ownership of `/var/run/postgresql' to postgres:postgres and with permissions 4777 then the errors are less, but postgresql still doesn't start: postgres@XXX:/etc/init.d$ ./postgresql-7.4 start * Starting PostgreSQL 7.4 database server:main Error: Could not change user id [fail] I think this maybe something in /etc/postgresql/7.4/pg_hba.log or /etc/postgresql/7.4/postgresql.conf yet I haven't found the solution to get PostgreQL going. What could be wrong here? How can this be fixed? What do I need to read? TIA Russell