Skip site navigation (1) Skip section navigation (2)

ignore TCP/IP question

From: Thomas Keller <kellert(at)ohsu(dot)edu>
To: Postgresql PDX_Users <pdxpug(at)postgresql(dot)org>
Subject: ignore TCP/IP question
Date: 2008-03-01 21:46:49
Message-ID: DF06EA02-6019-468D-A519-199786DCEC6A@ohsu.edu (view raw or flat)
Thread:
Lists: pdxpug
Well, I investigated the cgi script using DBI and DBD::Pg that was  
giving the error and discovered the connection string was the problem.
This is still curious, and I'd like to know why but I was able to fix  
it.
Here's the old $dsn variable:   ## this gave the "can't connect" error.
   my $dsn = 'dbi:Pg:dbname=db_name;host=server_name';

This fixed the problem:
  my $dsn = 'dbi:Pg:dbname=db_name';

So maybe there is something not quite right in my pg_hba.conf file. ??

thanks for any insights.

Tom
MMI Shared Resource Facility
503-494-2442
kellert at ohsu.edu



Responses

pdxpug by date

Next:From: Selena DeckelmannDate: 2008-03-02 18:36:15
Subject: Re: ignore TCP/IP question
Previous:From: Thomas KellerDate: 2008-03-01 21:08:42
Subject: TCP/IP connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group