Re: Create Data Base fails

Are you using advanced authentication in phppgadmin?

Could this be caused when phppgadmin is configured to
have the database superuser connect to template1 to
manage user logins?

Andrew Gould

--- Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> wrote:
> OK, the picture is the latest CVS of phpPgAdmin on
> PostgreSQl 7.3.1.
>
> I created a user with createDB option. Here OK.
>
> I connect to phpPgAdmin as that user and try to
> create a DB and I get this
> error:
>
> Error de SQL:
> ERROR: CREATE DATABASE: source database "template1"
> is being accessed by
> other users
>
> En la declaracio'n:
> CREATE DATABASE "phpbb" WITH ENCODING='LATIN1'
>
> I'm crossposting because I think it may be more of a
> PostgreSQL situation
> then a phpPgAdmin one.
>
> --
> Porqu usar una base de datos relacional cualquiera,
> si pods usar PostgreSQL?
>
-----------------------------------------------------------------
> Martn Marqus |
> mmarques(at)unl(dot)edu(dot)ar
> Programador, Administrador, DBA | Centro de
> Telematica
> Universidad Nacional
> del Litoral
>
-----------------------------------------------------------------
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend