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

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Error Message: ERROR: CREATE USER: permission denied
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E41A780D@ratbert.vale-housing.co.uk
обсуждение исходный текст
Список pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ben Trewern
> Sent: 22 August 2004 21:21
> To: lorena_m_v@hotmail.com; pgadmin-support@postgresql.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 по дате отправления:

Предыдущее
От: "Somchai Boongerd"
Дата:
Сообщение: Error Message: Invalid procedure call or argument
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Error Message: Invalid procedure call or argument