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@bugs.unl.edu.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 pod�s usar PostgreSQL?
>
-----------------------------------------------------------------
> Mart�n Marqu�s |
> mmarques@unl.edu.ar
> Programador, Administrador, DBA | Centro de
> Telematica
> Universidad Nacional
> del Litoral
>
-----------------------------------------------------------------
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend