X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4C2E0D1B49B for ; Fri, 16 Jan 2004 10:28:16 +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 04767-05 for ; Fri, 16 Jan 2004 06:27:47 -0400 (AST) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.189]) by svr1.postgresql.org (Postfix) with ESMTP id 6AE99D1B441 for ; Fri, 16 Jan 2004 06:27:44 -0400 (AST) Received: from [212.227.126.160] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1AhRCc-0007at-00 for pgsql-php@postgresql.org; Fri, 16 Jan 2004 11:27:46 +0100 Received: from [212.202.35.95] (helo=devel09.funky.ag) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1AhRCb-0005ry-00 for pgsql-php@postgresql.org; Fri, 16 Jan 2004 11:27:46 +0100 Date: Fri, 16 Jan 2004 11:30:23 +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: <549163046.20040116113023@radax.net> To: pgsql-php@postgresql.org Subject: can't create db MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:712a323af23365a8b6b0ed25deed0dd9 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/14 X-Sequence-Number: 2530 Hello proggers, 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 ----------------------------------------