Enrico Ortmann <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]