Re: Connecting via Unix sockets?

[John C. N. y L. <nj...@nt...>]

Heya,


To connect to your PostgreSQL server from PERL you'll, more often than
not, be using a Database driver, i.e. DBI:Pg or something..;-)  And
you're welcome to create or enhance the current PERL driver to support
unix sockets..

If you're thinking about security...  TCP sockets can still work for
your advantage, use your firewall rulesets to moderately block those
little script kiddies and system crackers.

By the way, how were you able to change PHP4 to use Unix Sockets for
PostgreSQL...  AFAIK, PHP used pgsql.so to connect to your PostgreSQL
server via TCP sockets...

From my "limited" experience...;-)  It would be better to separate your
DB storage facility from your Other services...  Then you can cluster
your DB's (wait for PostgreSQL 7.2+ or use some other method) and create
a HA web server cluster...  This would improve your performance.  It
does, however, depend on the amount of traffic you foresee..;-)

Cheers,


John Clark


Federico Sevilla III wrote:
> 
> Hi everyone,
> 
> I am not as much into Perl as I am into PHP4, but I was wondering, will it
> be possible to configure SQL Ledger to possibly connect to PostgreSQL via
> Unix sockets? Aside from a theoretical speed increase (however unfelt),
> forcing the postmaster to not listen on TCP might be a good security move
> for certain sites. On PHP4 this can be done by setting the protocol from
> tcp to unix. I don't know if this can be done with SQL-Ledger and Perl.
> Any gives?
> 
>  --> Jijo
> 
> --
> Federico Sevilla III  :: ji...@le...
> Network Administrator :: The Leather Collection, Inc.
> GnuPG Key: <http://jijo.leathercollection.ph/jijo.gpg>

-- 
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer III                      ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3113            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: nj...@nt...                        \   \


"Intelligence is the ability to avoid doing work, yet getting the work
done"
--Linus Torvalds