Re: can't alter user with the postgres user

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: Katy Earl <khaetee(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: can't alter user with the postgres user
Date: 2003-05-14 21:34:55
Message-ID: 3456.1052948095@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Octavio Alvarez 2003-05-15 00:50:04 MSAccess-like Last() with sorting before grouping
Previous Message Josh Berkus 2003-05-14 19:38:26 Re: can't alter user with the postgres user