Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: can't alter user with the postgres user
Date
Msg-id 200305141238.26534.josh@agliodbs.com
Whole thread Raw
In response to Re: can't alter user with the postgres user  (Katy Earl <khaetee@yahoo.com>)
Responses Re: can't alter user with the postgres user
List pgsql-novice
Tree view 
Katy,

> Yes, 'postgres' is the only line in pg_user.

Wow.  Frankly, I'm not sure how it's possible to install postgresql without a
superuser.  Perhaps your tech accidentally made himself the superuser, then
deleted his account to "fix" it?

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

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-novice by date:

Previous
From: "Fontenot, Paul"
Date:
Subject: Password changes
Next
From: Tom Lane
Date:
Subject: Re: can't alter user with the postgres user