pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedcoming ColdFusion support for PostgreSQL
4+ messages / 3 participants
[nested] [flat]
* coming ColdFusion support for PostgreSQL
@ 2000-02-03 18:36 Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Ross J. Reedstrom @ 2000-02-03 18:36 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [HACKERS] coming ColdFusion support for PostgreSQL
@ 2000-02-03 18:59 Lamar Owen <lamar.owen@wgcr.org>
parent: Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Lamar Owen @ 2000-02-03 18:59 UTC (permalink / raw)
To: Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>; +Cc: pgsql-hackers@postgresql.org; pgsql-interfaces
"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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] coming ColdFusion support for PostgreSQL
@ 2000-02-03 19:28 Ken J. Wright <ken@ori-ind.com>
0 siblings, 0 replies; 4+ messages in thread
From: Ken J. Wright @ 2000-02-03 19:28 UTC (permalink / raw)
To: Lamar Owen <lamar.owen@wgcr.org>; Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>; +Cc: pgsql-hackers@postgreSQL.org; pgsql-interfaces
>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.
My two cents (sense?).
/var/lib follows Redhat dist install, correct?
I just installed 6.5.3 from the rpms for the first time and was thrown off
just a little, because I have always compiled & installed from the sources
to the default of /usr/local/pgsql.
This caused me to update some environment variables (PGxxx & PATH), but
that's about it. I actually prefer to have the source install and the rpm
install remain in separate places. But I would suggest /var/lib/pgsql/data
just to be inline with the source install. BTW, the rpm install was a
breeze. Much appreciated ;-)
Ken
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [HACKERS] coming ColdFusion support for PostgreSQL
@ 2000-02-03 21:15 Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
parent: Lamar Owen <lamar.owen@wgcr.org>
0 siblings, 0 replies; 4+ messages in thread
From: Ross J. Reedstrom @ 2000-02-03 21:15 UTC (permalink / raw)
To: Lamar Owen <lamar.owen@wgcr.org>; +Cc: pgsql-hackers@postgresql.org; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-02-03 21:15 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-03 18:36 coming ColdFusion support for PostgreSQL Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
2000-02-03 18:59 ` Lamar Owen <lamar.owen@wgcr.org>
2000-02-03 21:15 ` Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
2000-02-03 19:28 Re: [INTERFACES] Re: [HACKERS] coming ColdFusion support for PostgreSQL Ken J. Wright <ken@ori-ind.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox