First off, thanks a ton for all the great replies to my previous post on databases and such. They really helped, and I think that I am on my way!

Now, here is a good question that I am really hoping one of my fellow monks can answer for me. Here is my dillema: I installed PostgreSQL (I know, I'll get flamed by some MySQL pyscho, but let me tell you I tried MySQL first, but it wouldn't install! Equal opprotunity to all, I swear!), but I installed it on a different server than the one my page is hosted on. The reason I opted to do this is two fold: first, I heard that it was possible (even recommended) to have your database and web servers seperate; and second, the server my page is hosted on is an old Cobalt RaQ2 which is pretty slow and running out of memory. The machine I installed PGSQL on is much faster - my reason.

My Dillema: How in the golly-gosh-darn-heck do I connect to server_1 (the PGSQL) server from a CGI script running on server_2 (my sites server) with DBI? Oh please, please, honorable ones, assist me in my quest to find the holy grail of perl knowledge! Ok, maybe not the grail, but atleast this little paper cup painted gold :-).

Thanks a ton to all!
R.Joseph

P.S. If it helps any, I don't believe that the two servers are directly networked, and even though housed in the same complex should be viewed as two entirely seperate servers.

In reply to Ha! Another database question! by r.joseph

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.