X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C5399D1DD5F for ; Fri, 16 Jan 2004 15:48:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66795-08 for ; Fri, 16 Jan 2004 11:47:47 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 89728D1DB75 for ; Fri, 16 Jan 2004 11:47:38 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0GFlgpH029947; Fri, 16 Jan 2004 10:47:42 -0500 (EST) To: Enrico Ortmann Cc: pgsql-admin@postgresql.org Subject: Re: can't create db from PHP In-reply-to: <339131515.20040116112951@radax.net> References: <339131515.20040116112951@radax.net> Comments: In-reply-to Enrico Ortmann message dated "Fri, 16 Jan 2004 11:29:51 +0100" Date: Fri, 16 Jan 2004 10:47:42 -0500 Message-ID: <29946.1074268062@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/134 X-Sequence-Number: 11997 Enrico Ortmann 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