Re: Setting up PostgreSQL on Debian...

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

On (14/06/05 09:32), John Hasler wrote:
> I 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.
> 
> Clive writes:
> > 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:
> 
> Read what I wrote.  The user (john) _has_ database creation privileges:

Apologies.  I think the OP was in a different situation .... but I may
be wrong.

Your case does sound like a bug.  I struggled with pgaccess at first and
found pgadmin3 easier to use until I'd learnt more SQL.  I created a
postgresql user with superuser and create database permissions and then
used pgadmin3 to create databases.  I'll go and check whether I can
create with pgaccess.

Regards

Clive

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