Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re^5: Trouble Connecting to PostgreSQL with DBD::Pg

by erix (Parson)
on Nov 16, 2010 at 19:58 UTC ( #871819=note: print w/replies, xml ) Need Help??

in reply to Re^4: Trouble Connecting to PostgreSQL with DBD::Pg
in thread Trouble Connecting to PostgreSQL with DBD::Pg

Yeah, you probably have no ident server.

afoken's advice is good (but careful: his URLs point to 9.0, which is slightly different). A few extra remarks:

Server restart can be avoided with:

select pg_reload_conf(); -- returns true on success

or, on the commandline: pg_ctl reload ...

Maybe not necessary now, but further down the road you may find it handy to organise access (permanently or temporary) via the ~/.pgpass file, and/or the PGPASSFILE environment variable, which you can have pointing to any .pgpass-like file. More info here;

Finally, read the Pg manual caveat on 'ident':

Heed the warning: The Identification Protocol is not intended as an authorization or access control protocol. --RFC 1413

Replies are listed 'Best First'.
Re^6: Trouble Connecting to PostgreSQL with DBD::Pg
by vendion (Scribe) on Nov 16, 2010 at 21:58 UTC

    Thank you for the help, I am to get MD5 auth working and that is good enough for me

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://871819]
[marto]: Corion, I can do some non-technical things, but there's no way for me to connect to the clients network.
[marto]: which is a shame, I had a really productive day yesterday
[Corion]: marto: Meh, so it'll be a day of cleaning out email...
[marto]: and hoped that I'd be able to continue the momentum :)
[marto]: I can't even access client email, nor my employers since those idiots moved to citrix
[marto]: it literally doesn't work. Also, via their citrix interface theres no way to open attachments, or upload an attachment for sending. The company policy is that you email you work account from a personal one, and forward it on from there :/

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2018-01-16 08:53 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (175 votes). Check out past polls.