This is probably somewhat off topic, but all the people who need to
know about this read this list, so, if you'll forgive me:

Background:
The project I'm working on is using ColdFusion as it's middleware,
accessing a PostgreSQL backend. To date, we've had to run on NT, using
ODBC to the DB on a separate box.  Allaire is in the process of releasing
a real live Linux version of their software (a native port, this time)
which I've been beta testing. I was pleased to discover that the unixODBC
driver worked (although I had to hand configure it into ColdFusion.)

Current news:
I just pulled the latest beta, and low and behold, it's checking to see
if PostgreSQL is installed, in order to install examples! It missed on my
box, since I run a Debian install, not the RedHat it's expecting, but
they're on the right track. Yep, the pgsql datasources are configurable
from within the CF adminstrator pages: excellent!

This _will_ lead to more commercial type users, I can guarantee.
Especially since the examples will be there. Lamar, we should make sure
that they detect the RPM install correctly, so that the examples just
work, right out of the box. I can image a lot of "throw together a demo,
using a DB backend, oh, here's PostgreSQL, I can use that" systems ending
up in production, since it'll just keep working.

Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005


Thu, 3 Feb 2000 12:36:14 -0600
"Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
coming ColdFusion support for PostgreSQL
"Ross J. Reedstrom" wrote:
> This _will_ lead to more commercial type users, I can guarantee.
> Especially since the examples will be there. Lamar, we should make sure
> that they detect the RPM install correctly, so that the examples just
> work, right out of the box. I can image a lot of "throw together a demo,
> using a DB backend, oh, here's PostgreSQL, I can use that" systems ending
> up in production, since it'll just keep working.

If you, as a beta tester for Cold Fusion, can let me know what they're
looking for, then I can oblige them with no problem. :-)

I am going to have to make it easier for third party software to detect
the RPM installation -- while things have settled down on where things
are, I have been considering moving some things around -- in particular,
the location of PGDATA is likely to move in 7.0 RPM's unless I hear a
cry otherwise.  Currently, PGDATA is /var/lib/pgsql, I'm considering
changing that to /var/lib/pgsql/data, which is more in line with the
standard installation.  This gives me the whole /var/lib/pgsql tree for
backups and other temp data that I need to move out of /usr/lib/pgsql.

I am open to suggestions -- environment variables perhaps?

I am going to look at Olivers Debian packages more closely so that I can
use the same envvar names for consistency, if I do use envvars.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Thu, 03 Feb 2000 13:59:07 -0500
Lamar Owen <lamar.owen@wgcr.org>
Re: [HACKERS] coming ColdFusion support for PostgreSQL
On Thu, Feb 03, 2000 at 01:59:07PM -0500, Lamar Owen wrote:
> "Ross J. Reedstrom" wrote:
> > This _will_ lead to more commercial type users, I can guarantee.
> > Especially since the examples will be there. Lamar, we should make sure
> > that they detect the RPM install correctly, so that the examples just
> > work, right out of the box. I can image a lot of "throw together a demo,
> > using a DB backend, oh, here's PostgreSQL, I can use that" systems ending
> > up in production, since it'll just keep working.
> 
> If you, as a beta tester for Cold Fusion, can let me know what they're
> looking for, then I can oblige them with no problem. :-)

Hmm, looks like it would have found either a RPM or source install,
but mis-sets a variable for the source install. I'll send you the
appropriate snippet from the install script privately. The script wants
to find createdb and psql to run, and uses the location of postmaster
as a clue.

> 
> I am going to look at Olivers Debian packages more closely so that I can
> use the same envvar names for consistency, if I do use envvars.
> 

Good plan. Coordinating the different packages will make everyone's job 
easier.

Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005



Thu, 3 Feb 2000 15:15:18 -0600
"Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
Re: [HACKERS] coming ColdFusion support for PostgreSQL
"Ross J. Reedstrom" wrote:
  >Background:
  >The project I'm working on is using ColdFusion as it's middleware,
  >accessing a PostgreSQL backend. To date, we've had to run on NT, using
  >ODBC to the DB on a separate box.  Allaire is in the process of releasing
  >a real live Linux version of their software (a native port, this time)
  >which I've been beta testing. I was pleased to discover that the unixODBC
  >driver worked (although I had to hand configure it into ColdFusion.)
  >
  >Current news:
  >I just pulled the latest beta, and low and behold, it's checking to see
  >if PostgreSQL is installed, in order to install examples! It missed on my
  >box, since I run a Debian install, not the RedHat it's expecting, but
  >they're on the right track. Yep, the pgsql datasources are configurable
  >from within the CF adminstrator pages: excellent!
 
If you can give me a contact, I would like to help them set it up as a
Debian package.

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "O come, let us worship and bow down; let us kneel 
      before the LORD our maker."            Psalms 95:6 



Thu, 03 Feb 2000 21:41:23 +0000
"Oliver Elphick" <olly@lfix.co.uk>
Re: [INTERFACES] coming ColdFusion support for PostgreSQL 