Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B380B2E002D for ; Fri, 15 Feb 2008 06:37:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 80893-03 for ; Fri, 15 Feb 2008 06:37:35 -0400 (AST) Received: from hu-out-0506.google.com (hu-out-0506.google.com [72.14.214.233]) by postgresql.org (Postfix) with ESMTP id EB1A42E002C for ; Fri, 15 Feb 2008 06:37:39 -0400 (AST) Received: by hu-out-0506.google.com with SMTP id 22so10639222hug.23 for ; Fri, 15 Feb 2008 02:37:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:references; bh=qhFE9065F2gbFSEXlD3hhdIng+ua0TvFLKCRUVBgg+M=; b=nf7kQdmmB8cTi+cWtyoqFqxQ4Bz5FYhDYT6wBEEy2U97ux2e9ffojOL6OO8QxEDQU0NDcB7oMOLV71njoDQBOmGe3zwupjaDWoV6f1PDt+8s5gpVk+lhAKmjeaPvkNuf0pXQADycbMaiw5YUD7if59OVUbMcUKen887KvnVgtYM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:references; b=rCnbaTLWvQOf9OT/wwl90WLlSVUO8sZOlxcjHdAiOo/H6Z08CUTkP2clkGee4sDEezNAu/FOigQmA4+IREiGW6job0YDeb1E+SDi257J8dnJEiTzSAyrw3j5V8UtjPi06gkzpTb8U8wYSzjiB3OvlfXxkM1w5aMb6ve5pKFNhYU= Received: by 10.78.136.9 with SMTP id j9mr2991765hud.74.1203071858263; Fri, 15 Feb 2008 02:37:38 -0800 (PST) Received: by 10.78.150.15 with HTTP; Fri, 15 Feb 2008 02:37:38 -0800 (PST) Message-ID: Date: Fri, 15 Feb 2008 10:37:38 +0000 From: "Peter Childs" Subject: Re: How to re-own db cluster Cc: pgsql-admin@postgresql.org In-Reply-To: <135dba0802150228i6b8175f0w36d940654f6e9698@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10215_3079758.1203071858259" References: <135dba0802150228i6b8175f0w36d940654f6e9698@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/175 X-Sequence-Number: 28249 ------=_Part_10215_3079758.1203071858259 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 15/02/2008, Vikram Vincent wrote: > > Hello, > I was trying to install a student information system called Centre which > failed to connect to postgres for reasons I have still been unable to > isolate. In order to restart the entire procedure of installation of > database and Centre, I removed the 'postgres' user and group that owned the > database and then readded them only to get the following error: > "Stopping PostgreSQL 8.3 database server: main > Error: The cluster is owned by user id 110which does not exist anymore > failed!" > How can I re-own the cluster? I cannot uninstall the postgresql-8.3 deb > using 'dpkg --purge postgesql-8.3'? Reinstalling gives similar > configuration errors. I use Debian 'Lenny'. > Thank you. > Regards, > Re-create the postgres user with the right user id. I believe that should be "adduser -UID 110 postgres" there are more complex answers but this is probably the simplest. Regards PEter ------=_Part_10215_3079758.1203071858259 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On 15/02/2008, Vikram Vincent <vincentvikram@gmail.com> wrote:
Hello,
I was trying to install a student information system called Centre which failed to connect to postgres for reasons I have still been unable to isolate. In order to restart the entire procedure of installation of database and Centre, I removed the 'postgres' user and group that owned the database and then readded them only to get the following error:
"Stopping PostgreSQL 8.3 database server: main
Error: The cluster is owned by user id 110which does not exist anymore
failed!"
How can I re-own the cluster? I cannot uninstall the postgresql-8.3 deb using 'dpkg --purge postgesql-8.3'? Reinstalling gives similar configuration errors. I use Debian 'Lenny'.
Thank you.
Regards,

Re-create the postgres user with the right user id. I believe that should be "adduser -UID 110 postgres" there are more complex answers but this is probably the simplest.

Regards

PEter
------=_Part_10215_3079758.1203071858259--