Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D79AB13364DE for ; Thu, 7 Apr 2011 13:35:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 91937-04 for ; Thu, 7 Apr 2011 16:35:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from salmo.appl-ecosys.com (appl-ecosys.com [216.99.206.23]) by mail.postgresql.org (Postfix) with ESMTP id 84CE3133616B for ; Thu, 7 Apr 2011 13:35:19 -0300 (ADT) Received: by salmo.appl-ecosys.com (Postfix, from userid 1000) id BCC7037BC6; Thu, 7 Apr 2011 09:35:18 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by salmo.appl-ecosys.com (Postfix) with ESMTP id B177137B42 for ; Thu, 7 Apr 2011 09:35:18 -0700 (PDT) Date: Thu, 7 Apr 2011 09:35:18 -0700 (PDT) From: Rich Shepard To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 In-Reply-To: <201104070920.37258@hal.medialogik.com> Message-ID: References: <201104070920.37258@hal.medialogik.com> User-Agent: Alpine 2.00 (LNX 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/4 X-Sequence-Number: 4166 On Thu, 7 Apr 2011, Alan Hodgson wrote: > Can you connect to the database with psql using the same credentials? PHP > will use the same underlying postgresql library to connect. Alan, If you mean can I as a user connect to that same database, the answer is yes: [rshepard@salmo ~]$ psql cms psql (9.0.3) Type "help" for help. cms=# \d List of relations Schema | Name | Type | Owner --------+-----------------------------------+----------+---------- public | cms_additional_htmlblob_users | table | rshepard public | cms_additional_htmlblob_users_seq | sequence | rshepard public | cms_additional_users | table | rshepard public | cms_additional_users_seq | sequence | rshepard public | cms_admin_bookmarks | table | rshepard public | cms_admin_bookmarks_seq | sequence | rshepard public | cms_admin_recent_pages | table | rshepard public | cms_admin_recent_pages_seq | sequence | rshepard public | cms_adminlog | table | rshepard public | cms_content | table | rshepard public | cms_content_props | table | rshepard public | cms_content_props_seq | sequence | rshepard public | cms_content_seq | sequence | rshepard public | cms_crossref | table | rshepard public | cms_css | table | rshepard public | cms_css_assoc | table | rshepard public | cms_css_seq | sequence | rshepard etc. So, what can I do here? Rich