Thread: coming ColdFusion support for PostgreSQL
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
"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
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
"Ross J. Reedstrom" wrote: >Background: >The project I'm working on is using ColdFusion as it's middleware, >accessing aPostgreSQL backend. To date, we've had to run on NT, using >ODBC to the DB on a separate box. Allaire is in the processof 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 ID32B8FAA1 ======================================== "O come, let us worship and bow down; let us kneel before the LORD our maker." Psalms 95:6