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 CB081D1B500 for ; Fri, 16 Jan 2004 10:27:59 +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 05139-02 for ; Fri, 16 Jan 2004 06:27:31 -0400 (AST) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.184]) by svr1.postgresql.org (Postfix) with ESMTP id 865ABD1B446 for ; Fri, 16 Jan 2004 06:27:13 -0400 (AST) Received: from [212.227.126.161] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1AhRC6-0008Jc-00 for pgsql-admin@postgresql.org; Fri, 16 Jan 2004 11:27:14 +0100 Received: from [212.202.35.95] (helo=devel09.funky.ag) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1AhRC6-0000H0-00 for pgsql-admin@postgresql.org; Fri, 16 Jan 2004 11:27:14 +0100 Date: Fri, 16 Jan 2004 11:29:51 +0100 From: Enrico Ortmann X-Mailer: The Bat! (v2.0 Beta/6) CD5BF9353B3B7091 Reply-To: Enrico Ortmann Organization: RADAX X-Priority: 3 (Normal) Message-ID: <339131515.20040116112951@radax.net> To: pgsql-admin@postgresql.org Subject: can't create db from PHP MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:d15e8270625ad98023d97bc6953cd9a8 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/130 X-Sequence-Number: 11993 Hello admins, I got a strange problem while creating a database FROM PHP: I connect from SuSE shell via php to a PG-server [7.3.2] using command $conn = @pg_pconnect("host=db port=5432 user=postgres dbname=template1"); [db is an Alias in /etc/hosts an points to 192.168.0.200] Then I create a database using command pg_exec($conn,"CREATE DATABASE dvl_ao_27_beta;"); All works fine! 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? Enrico Ortmann ----------------------------------------