Skip site navigation (1) Skip section navigation (2)

Re: Superuser

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Reinhard Hnat <hnat(at)logotronic(dot)co(dot)at>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Superuser
Date: 2004-06-29 09:36:25
Message-ID: 40E13819.5020603@e-trolley.de (view raw or flat)
Thread:
Lists: pgsql-novice
Reinhard Hnat wrote:
> By mistake I took away superuser rights from my postgresql Admin. Any idea
> how to get  it back? There is no other superuser in the database.

How did you remove it?
Maybe pg_hba.conf is what you're looking for.
Or the pg_shadow table for passwords etc.

hth
-- 
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de

In response to

  • Superuser at 2004-06-29 09:02:45 from Reinhard Hnat

pgsql-novice by date

Next:From: Tom LaneDate: 2004-06-29 14:07:23
Subject: Re: Superuser
Previous:From: Reinhard HnatDate: 2004-06-29 09:02:45
Subject: Superuser

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group