Postgres Pro
Downloads
Home   >   mailing lists

Re: can't alter user with the postgres user - Mailing list pgsql-novice

From Tom Lane
Subject Re: can't alter user with the postgres user
Date
Msg-id 3456.1052948095@sss.pgh.pa.us
Whole thread Raw
In response to Re: can't alter user with the postgres user  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
> Wow.  Frankly, I'm not sure how it's possible to install postgresql without a
> superuser.

You can't.  The original superuser account must have been deleted, or
perhaps altered to not have superuser privs anymore.

> In any case, I think re-installation will be your easiest way to fix this.

I believe it's possible to create a new superuser from a standalone
backend.  However, if this is a test installation with no valuable data
in it, a re-install probably is the easiest path.

            regards, tom lane

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: can't alter user with the postgres user
Next
From: Dani Oderbolz
Date:
Subject: Re: MD5 encryption, Was: Multilingual database