Re: Setting up PostgreSQL on Debian...
On (14/06/05 06:47), Redefined Horizons wrote:
> On 6/14/05, Clive Menzies <firstname.lastname@example.org> wrote:
> > On (13/06/05 20:41), John Hasler wrote:
> > > I get exactly the same error here. The user I am running pgAccess as is a
> > > PostgreSQL user. When I run psql I can create the database and then open
> > > it in pgAccess, but I can't create it in pgAccess.
> > >
> > > Looks like a but.
> > but what? ;)
> > It's not a bug. If you've created a user and you want that user to be
> > able to create databases or users, you need to grant those privileges,
> > initially, as user postgres:
> > CREATE (ALTER) USER <username> PASSWORD <passwd> CREATEDB CREATEUSER;
> How do you sign into pgAccess as the user with the creation
> privileges? I didn't see a place to log on directly in pgAccess.
That user needs to be created (by user 'postgres') with creation
> Does it use the permissions of whatever current user is logged into
Yes. You're running pgaccess as the Debian user logged in which means that
user needs the requisite permissions to create databases and other users
(unless you want to restrict that to user postgres).
> If I have a user created for Debian, do I simply log in as postgres
> and grant that user the create privileges?
Yes. Login to the server as postgres create your Debian user with
create privileges and thereafter you don't need to login as postgres.
> Are the "Debian System" users and the PostgreSQL users the same? (For
> example, If I create a new Linux user JoeBlow, is he already a
> PostgreSQL user by default? Or would I have to create a "Postgresql"
> user called JoeBlow also?)
No. Not unless you specifically create PostgreSQL user profiles for
every system user.
...strategies for business