<br><br><div class="gmail_quote">On Sat, May 21, 2011 at 5:53 AM, Ivan Sergio Borgonovo <span dir="ltr"><<a href="mailto:mail@webthatworks.it">mail@webthatworks.it</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
On Fri, 20 May 2011 21:10:32 -0400<br>
<div class="im">mark bradley <<a href="mailto:gopearls42@gmail.com">gopearls42@gmail.com</a>> wrote:<br>
<br>
</div><div class="im">> Hi again,<br>
><br>
> I've upgraded to PostgreSQL 8.4 now (yeah, I read the docs<br>
> again :) ) but I'm still getting the same error.<br>
><br>
> When I tcpdump at the database server (a different host), I don't<br>
> see any traffic (however when I use psql from the command like I<br>
> do see the traffic).<br>
><br>
> Is there a log file generated during the install process that I<br>
> could check?<br>
<br>
</div>psql connects through sockets, Drupal (was used to?) connect through<br>
tcp.<br>
Give a look to pg_hba.conf for connection permission.<br>
PHP had (has?) a problem and if you really want to have a socket<br>
connection you had to skip "host=localhost" in the connection string.<br>
Drupal is using a completely new DB abstraction layer and this may<br>
not be needed anymore.<br>
<br>
--<br>
Ivan Sergio Borgonovo<br>
<a href="http://www.webthatworks.it" target="_blank">http://www.webthatworks.it</a><br>
<font color="#888888"><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></font></blockquote><div><br>Hi Ivan,<br><br>In my psql command-line test I'm actually connecting over TCP since it's between two hosts.<br>
<br>Just to clarify, I have two servers -- 'web' and 'db' (so really my string would be host="db" if I was setting it manually). Using psql I can connect to the database from either host so I'm fairly confident in my pg_hba file.<br>
<br>When I'm going through the install script I do not see any TCP traffic to port 5432 on either server (but when I'm using psql I do see the traffic).<br></div></div><br>Do you know if the install script produces a log that can be used for debugging?<br>
<br>Thanks,<br>Mark<br>