Re: Setting up PostgreSQL on Debian...

[Clive Menzies <clive@clivemenzies.co.uk>]

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;

Regards

Clive

-- 
www.clivemenzies.co.uk ...
...strategies for business