Problem with connectivity

From: Andy Glew <andyfives(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with connectivity
Date: 2007-10-04 16:12:55
Message-ID: 809243.45915.qm@web27614.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Please help.. I have hit a bit of a brick wall with this.

I have a problem concerning connecting to my database. I want to log webserver transactions into a postgresql db. For development the webserver is my local pc and the postgresql db is setup on a server, both accessable through the companies network.

This is in a windows XP environment.

Now when I try to access the db through my webpage (generated using perls Template Toolkit) I get the following:-

DBI connect failed: Couldn't connect to cphnbdev3:5432/tcp: IO::Socket::INET: connect: Unknown error at C:/Perl/site/lib/DBD/PgPP.pm line 124

My connection string shouldn't be much of a problem as I use something similar (different port granted) for our MySQL db.
DBI:mysql:database=skylightslogs;host=Cphxxdev;port=3306

To start with I installed postgresql on my local PC and managed to get it to work just fine using the DBI utility.

I am a newby with postgresql, generally very impressed but would like some help in solving my little problem... What could be wrong, I tried changing the port, the host name in the pgAdminIII and loads of other things too?

Thanks in advance

___________________________________________________________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-10-04 16:21:07 Re: good sql tutorial
Previous Message Geoffrey 2007-10-04 16:06:23 Re: good sql tutorial