Re: Can't connect to postgresql on win32 using Perl - Mailing list pgsql-novice

From Ronald Schmidt
Subject Re: Can't connect to postgresql on win32 using Perl
Date
Msg-id 004f01c2cb90$1bf40020$8f0c80ac@PRECISION1
Whole thread Raw
In response to Re: Can't connect to postgresql on win32 using Perl  ("Reshat Sabiq" <sabiq@purdue.edu>)
Responses Re: Can't connect to postgresql on win32 using Perl
List pgsql-novice
As my original email stated, I have postmaster running as a service.  I have looked at all three of the files you mentioned and do not understand why their default configurations would interfere with connections from Perl DBI/DBD.
 
Ronald Schmidt
----- Original Message -----
Sent: Sunday, February 02, 2003 6:51 PM
Subject: Re: [NOVICE] Can't connect to postgresql on win32 using Perl

I don’t know a lot myself, but postmaster should be running, and you may need to play with:

postgres.conf

pg_hba.conf

pg_ident.conf

Sincerely,
r.

-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Ronald Schmidt
Sent: Sunday, February 02, 2003 4:51 PM
To:
pgsql-novice@postgresql.org
Subject: [NOVICE] Can't connect to postgresql on win32 using Perl

 

I am new to PostgreSQL but have gotten to the point where I have postmaster running as a service on Windows 2000 and can connect to the server by typing 'psql mydb'.  I cannot however get a Perl/DBI connection to my database.  I have tried both DBD::Pg with ActiveState Perl 5.6.1 and DBD::PgPP with ActiveState Perl 5.8.0.  I installed PostgreSQL 7.3.1 with cygwin.  The error messages I get with each type of connection are listed below:

 

(Perl 5.6.1 and DBD::Pg)

DBI->connect(dbname=mydb) failed: could not create socket: An address incompat
 at x.pl line 5equested protocol was used.
could not create socket: An address incompatible with the requested protocol was
 at x.pl line 5.

 

(Perl 5.8.0 and DBD::PgPP)

DBI->connect(dbname=mydb) failed: Couldn't connect to /tmp/.s.PGSQL.5432:  at
c:/perl58/site/lib/DBD/PgPP.pm line 124
 at x.pl line 5

I am really more interested in getting the connection to work with Perl 5.6.1 but have verified that /tmp/.s.PGSQL5432 exists and seems to have the right permissions.

 

Ronald Schmidt

 

pgsql-novice by date:

Previous
From: "paul butler"
Date:
Subject: Re: Creation of VIEWS not working.... THANKS :-)
Next
From: mjoseph@inautix.com
Date:
Subject: Database access problem : SOS