X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4FC0C56903 for ; Mon, 21 Mar 2005 16:16:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42289-10 for ; Mon, 21 Mar 2005 16:16:01 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 1DB94568F8 for ; Mon, 21 Mar 2005 16:15:59 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j2LGFtQX030112 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Mon, 21 Mar 2005 09:15:58 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j2LGFtni022268; Mon, 21 Mar 2005 09:15:55 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j2LGFtMv022267; Mon, 21 Mar 2005 09:15:55 -0700 (MST) (envelope-from mfuhr) Date: Mon, 21 Mar 2005 09:15:55 -0700 From: Michael Fuhr To: germ germ Cc: pgsql-php@postgresql.org Subject: Re: PHP and Postgres setup Message-ID: <20050321161555.GA22145@winnie.fuhr.org> References: <20050321131047.93504.qmail@web53406.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050321131047.93504.qmail@web53406.mail.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/51 X-Sequence-Number: 3066 On Mon, Mar 21, 2005 at 05:10:46AM -0800, germ germ wrote: > I have installed Postgres on Suse 9.1 and created a > test database but am unable to connect to it through > PHP. Please show the PHP code you're using to connect and any error messages you get. Without seeing what you're doing and what's happening, guesses about what's wrong would have little basis. > What do I need to configure in order for Appache and > Postgres to be able to talk back and forth? See the "Database Users and Privileges" and "Client Authentication" chapters in the PostgreSQL documentation. Verify that you can connect to the database with psql before trying it with PHP. Make sure PHP has PostgreSQL support (you can check by examining phpinfo() output). -- Michael Fuhr http://www.fuhr.org/~mfuhr/