pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Childs <peterachilds@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to re-own db cluster
Date: Fri, 15 Feb 2008 10:37:38 +0000
Message-ID: <a2de01dd0802150237w60873ad6sf69342ac6acfeea4@mail.gmail.com> (raw)
In-Reply-To: <135dba0802150228i6b8175f0w36d940654f6e9698@mail.gmail.com>
References: <135dba0802150228i6b8175f0w36d940654f6e9698@mail.gmail.com>

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

view thread (3+ messages)  latest in thread

Message-ID: <a2de01dd0802150237w60873ad6sf69342ac6acfeea4@mail.gmail.com>
Permalink:  ../a2de01dd0802150237w60873ad6sf69342ac6acfeea4@mail.gmail.com/
Also on:    postgresql.org/message-id/a2de01dd0802150237w60873ad6sf69342ac6acfeea4@mail.gmail.com

 · 

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: peterachilds@gmail.com
  Subject: Re: How to re-own db cluster
  In-Reply-To: <a2de01dd0802150237w60873ad6sf69342ac6acfeea4@mail.gmail.com>

* 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