Re: Create Data Base fails

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