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

Re: Help: Dumb newbie locked himself out!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Balazs Wellisch" <balazs(at)bwellisch(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Help: Dumb newbie locked himself out!
Date: 2002-07-17 19:52:29
Message-ID: 16415.1026935549@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Balazs Wellisch" <balazs(at)bwellisch(dot)com> writes:
> UPDATE pg_shadow SET usesuper = true WHERE usename = 'postgres';
> ERROR:  pg_shadow: Permission denied.

Hmm.  I forgot that you'd need usecatupd privilege to do that.

> Any other suggestions? I appreciate your help.

I think you may be stuck :-( ... unless you want to risk editing the
pg_shadow file with a binary-file editor.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Søren NeigaardDate: 2002-07-17 20:43:42
Subject: How do I only allow one group access to my database
Previous:From: Balazs WellischDate: 2002-07-17 17:58:17
Subject: Re: Help: Dumb newbie locked himself out!

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