Skip site navigation (1) Skip section navigation (2)

Re: Error Message: ERROR: CREATE USER: permission denied

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Ben Trewern" <ben_trewern(at)hotmail(dot)com>,<lorena_m_v(at)hotmail(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Error Message: ERROR: CREATE USER: permission denied
Date: 2004-08-23 07:08:06
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E41A780D@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Ben Trewern
> Sent: 22 August 2004 21:21
> To: lorena_m_v(at)hotmail(dot)com; pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Error Message: ERROR: CREATE 
> USER: permission denied
> 
> I don't think this is a pgAdmin problem.  You need to log in 
> as a superuser account to create a user.  The superuser is 
> usually called postgres in a standard PostgreSQL install 
> although any user can be made a superuser (See ALTER USER 
> <username> CREATEUSER).
> 
> Try
> 
> CREATE USER <username>;
> 
> via psql or the sql window in pgAdmin to see if that does it.

Yes, that's good advice. I would like to add that pgAdmin II is no
longer actively supported, and the 7.2.1 native port of PostgreSQL that
you appear to be using has never been properly tested with pgAdmin
(though it *should* be OK). 

If this is a new project you are working on, you might want to consider
upgrading to PostgreSQL 8.0 beta1 (with a view to upgrading to the
release version as soon as available), which comes with pgAdmin III if
you download the installer build from
http://pgfoundry.org/project/showfiles.php?group_id=1000007. Both are
being actively developed and supported.

Regards, Dave

> >-- Application Information --
> >
> >Name: pgAdmin II
> >Version: 1.6.0
> >Descripton:
> >
> >-- Database Information --
> >
> >Version: 7.2.1
> >Descripton: PostgreSQL 7.2.1 on i686-pc-winnt-msdev, 
> compiled by msdev 
> >6.0


pgadmin-support by date

Next:From: Dave PageDate: 2004-08-23 07:12:23
Subject: Re: Error Message: Invalid procedure call or argument
Previous:From: Somchai BoongerdDate: 2004-08-23 06:25:27
Subject: Error Message: Invalid procedure call or argument

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group