Your PerlSetVar idea is good. You can set a key there that you use to pull the values from a hash in your startup.pl or a similar config file. You can also do something where you pass a value to the httpd and use that to switch between sets of PerlSetVars in httpd.conf.

On command-line: 

> httpd -DPROD

[download]
In httpd.conf: 
<IfDefine PROD>
  PerlSetVar DATABASE_NAME foo
  PerlSetVar DATABASE_USER bar
  PerlSetVar DATABASE_PASS baz
</IfDefine>

[download]

You can do fancier stuff too. In one place that I worked, we used a small script with Template Toolkit to re-generate httpd.conf for different environments based on a small file of values keyed on different environments. It was nice because we had the ability to do inheritance, where we would define defaults and override them for development or other special cases.

In reply to Re: apache::dbi how to switch between development or production database? by perrin
in thread apache::dbi how to switch between development or production database? by corporate_gadfly

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.