Re: can't create db from PHP

Enrico Ortmann <pg.admin@radax.net> writes:
> But when I connect using the IP-adress instead of the alias
> $conn = @pg_pconnect("host=192.168.0.200 port=5432 user=postgres dbname=template1");
> the handle is valid as well, but then if I want to create the database I got the error
> ERROR:  CREATE DATABASE: source database "template1" is being accessed by other users

> Does anybody have an idea what goes wrong in case I use the IP?

This message has nothing to do with how you connect.  I suspect you
forgot to disconnect the other connection.

            regards, tom lane