pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to re-own db cluster
3+ messages / 2 participants
[nested] [flat]

* How to re-own db cluster
@ 2008-02-15 10:28  Vikram Vincent <vincentvikram@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Vikram Vincent @ 2008-02-15 10:28 UTC (permalink / raw)
  To: 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/

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How to re-own db cluster
@ 2008-02-15 10:37  Peter Childs <peterachilds@gmail.com>
  parent: Vikram Vincent <vincentvikram@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Childs @ 2008-02-15 10:37 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How to re-own db cluster
@ 2008-02-15 13:26  Vikram Vincent <vincentvikram@gmail.com>
  parent: Peter Childs <peterachilds@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Vikram Vincent @ 2008-02-15 13:26 UTC (permalink / raw)
  To: pgsql-admin

Hello,
Peter Childs wrote:
> 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.
Thanks Peter. Your idea was useful in solving this problem.
Regards,

-- 
Vikram Vincent
+91 9448810822
http://www.swatantra.org
http://translate.swatantra.org/




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2008-02-15 13:26 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-15 10:28 How to re-own db cluster Vikram Vincent <vincentvikram@gmail.com>
2008-02-15 10:37 ` Peter Childs <peterachilds@gmail.com>
2008-02-15 13:26   ` Vikram Vincent <vincentvikram@gmail.com>

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