How to re-own db cluster

From: "Vikram Vincent" <vincentvikram(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to re-own db cluster
Date: 2008-02-15 10:28:36
Message-ID: 135dba0802150228i6b8175f0w36d940654f6e9698@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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,
--
Vikram Vincent
+919448810822
http://www.swatantra.org/
http://translate.swatantra.org/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Childs 2008-02-15 10:37:38 Re: How to re-own db cluster
Previous Message Tore Halset 2008-02-15 09:17:59 pg_xlog symlink