Re: Can't connect to postgresql on win32 using Perl
От | Ronald Schmidt |
---|---|
Тема | Re: Can't connect to postgresql on win32 using Perl |
Дата | |
Msg-id | 007101c2cc63$2ad44c20$7dd389ac@PRECISION1 обсуждение исходный текст |
Ответ на | Re: Can't connect to postgresql on win32 using Perl ("Reshat Sabiq" <sabiq@purdue.edu>) |
Список | pgsql-novice |
I found the solution on Google groups: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=000c01c2 6356%24d9ad5d70%240100a8c0%40uz2.ca&rnum=19&prev=/groups%3Fq%3DDBD::pg%2Bcyg win%2BPostgreSQL%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26start%3D10%26 sa%3DN ----- Original Message ----- From: "Andrew McMillan" <andrew@catalyst.net.nz> To: "Ronald Schmidt" <ronaldws@software-path.com> Cc: <pgsql-novice@postgresql.org> Sent: Monday, February 03, 2003 2:13 PM Subject: Re: [NOVICE] Can't connect to postgresql on win32 using Perl > On Tue, 2003-02-04 at 03:24, Ronald Schmidt wrote: > > 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. > > pg_hba.conf defines the limitations to access and authenticate with the > database - that's the most likely of the three to need editing in your > case. > > I've never used the Windows version so I don't know if it supports local > socket access, but for TCP access you need to ensure you are running > PostgreSQL with the -i switch. > > Is there a Windows equivalent to "netstat"? You might check to see > whether the DB is listening. > > Cheers, > Andrew. > -- > --------------------------------------------------------------------- > Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington > WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St > DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 > Survey for nothing with http://survey.net.nz/ > --------------------------------------------------------------------- > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
В списке pgsql-novice по дате отправления: