Postgres Pro
Downloads
Home   >   mailing lists

Thread: Create Data Base fails

Create Data Base fails

From
Martin Marques
Date:
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
-----------------------------------------------------------------

Re: Create Data Base fails

From
Andrew Gould
Date:
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

Re: Create Data Base fails

From
Martin Marques
Date:
On Mar 01 Jul 2003 10:11, Andrew Gould wrote:
> 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?

phpPgAdmin has nothing to do, now that I made some tests.

1) I conected to template1 using user postgres using psql
2) With user bbuser (which can create databases) I try to create a
database from inside psql:

phpbb=> create database pruebatp;
ERROR:  CREATE DATABASE: source database "template1" is being accessed by
other users
phpbb=>

So it seems that when template1 is been accessed, create database can't be
used (there seems to be a good reason for that, no?).

Now, could this be a problem with phpPgAdmin conecting by default to
template1?

--
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
-----------------------------------------------------------------