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 200305131232.45953.josh@agliodbs.com
Whole thread Raw
In response to can't alter user with the postgres user  (Katy Earl <khaetee@yahoo.com>)
List pgsql-novice
Tree view 
Katy,

> I'm brand new to postgres, and I didn't install it on
> the machine I'm using so I don't entirely understand
> its configuration. But isn't the 'postgres' user
> supposed to be like the root user for PostgreSQL?
> Well, for some reason, my postgres user doesn't have
> the privilege to create other users...

Who installed it?  They may not have made "postgres" the superuser.  Who owns
the PostgreSQL directories?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-novice by date:

Previous
From: Katy Earl
Date:
Subject: can't alter user with the postgres user
Next
From: Rory Campbell-Lange
Date:
Subject: Re: Advisable to move SQL from PHP to functions?