From: | "Peter Childs" <peterachilds(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How to re-own db cluster |
Date: | 2008-02-15 10:37:38 |
Message-ID: | a2de01dd0802150237w60873ad6sf69342ac6acfeea4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 15/02/2008, Vikram Vincent <vincentvikram(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Suresh Gupta VG | 2008-02-15 10:38:50 | error while extracting the database |
Previous Message | Vikram Vincent | 2008-02-15 10:28:36 | How to re-own db cluster |