P is for Practical | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I know it works You can only conclude that it works from the server itself. Is your perl program also running & connecting from the server? Your code works for me. That means probably that you have to tweak your pg_hba.conf: Pg authentication docs (NOTE: change '/current/' to whatever pg version you use; 'current' means Pg version 9.0 - and yes, it has changed). Oh wait, I see you have 8.4, so here: 8.4 Pg authentication docs Keep in mind that the first matching line (in pg_hba.conf) will be used. irc freenode #postgresql is often the quickest way to get postgres database problems solved, or at least, discussed. The DBD:Pg author(s) are often there too. UPDATE: if you leave the $dsn 'host=' param away, connection will be done via unix sockets (as opposed to tcp/ip). In reply to Re: Trouble Connecting to PostgreSQL with DBD::Pg
by erix
|
|