Re: Setting up PostgreSQL on Debian...

[John Hasler <jhasler@debian.org>]

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:

template1=# \du
              List of database users
 User name  | User ID |         Attributes         
------------+---------+----------------------------
 john       |     102 | superuser, create database
 postgres   |       1 | superuser, create database
 sql-ledger |     101 | superuser, create database
 www-data   |     100 | create database
-- 
John Hasler