DBI/DBD-Pg/perl question

Yes, I would like to know if you can get around that.. I had to install Postgres
on each machine that accessed the database.

Brian wrote:

I have a server which runs Postgres 6.3 under linux. On this system perl,
DBI-0.93, and DBD-Pg are installed. This machine can do accesses and
operations to the database with no problems. This machine is called
"earth".

What I am wanting to do, is allow say 20 other machines access to this
database via Perl/DBI/DBD.

Do I have to install Postgres-6.3 on *every* machine that I want to be
able to access the Postgres database on earth, or is there a way to just
compile DBD/DBI/perl on these "client only" machines?

The docs for DBD-Pg say you need to install Postgres-6.3 on the machine
for DBD-Pg to work. I am just trying to find out if this is really
necessary, is there such a thing as a "client only" installation of
Postgres that is a little smaller maybe? If I have to install
Postgres-6.3 on every machine i guess I will, I just didn't want to
maintain that many different copies of one program.

Thank you for your help,

Brian

/-------------------------- signal@shreve.net -----------------------------\
| Brian Feeny | USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting, online stores, |
| ShreveNet Inc. | USR Pilot | Dial-Up 14.4-56k, ISDN & LANs |
| 89 CRX DX w/MPFI, lots of |-=*:Quake:*=-| http://www.shreve.net/ |
| mods/Homepage coming soon |LordSignal/SN| Quake server: 208.206.76.47 |
\-------------------------- 318-222-2638 x109 -----------------------------/

--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Michael - System Administrator              Working in Cheap Canadian Dollars
Unix Administration - WebSite Hosting - Network Services - Programming
Wizard Internet Services - TechnoWizard Computers - Wizard Tower TechnoServices
------------------------------------------------------------------------------
(604) 589-0037          Beautiful British Columbia, Canada
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

On Sat, 4 Jul 1998, Brian wrote:

I have a server which runs Postgres 6.3 under linux. On this system perl,
DBI-0.93, and DBD-Pg are installed. This machine can do accesses and
operations to the database with no problems. This machine is called
"earth".

What I am wanting to do, is allow say 20 other machines access to this
database via Perl/DBI/DBD.

Do I have to install Postgres-6.3 on *every* machine that I want to be
able to access the Postgres database on earth, or is there a way to just
compile DBD/DBI/perl on these "client only" machines?

The docs for DBD-Pg say you need to install Postgres-6.3 on the machine
for DBD-Pg to work. I am just trying to find out if this is really
necessary, is there such a thing as a "client only" installation of
Postgres that is a little smaller maybe? If I have to install
Postgres-6.3 on every machine i guess I will, I just didn't want to
maintain that many different copies of one program.

For DBI/DBD to work, you'll need libpq, which contains the actual code to
interface with PostgreSQL. It should be possible to only install (ie.
copy) libpq.{a|so} and the necessary include-files to those machines, and
then install the DBD driver. You could probably put all the necessary
files in a .tar.gz file (write a little script to do this), so it's easy
to distribute those files (and to keep the machines up-to-date when you
upgrade PostgreSQL).

Maybe it's an idea to include such a script in the main distribution. It
should place all necessary libraries and include-files, and maybe the
user tools like psql.

If you're running a Debian/Linux system, you're in luck. There already
exist the necessary packages (libpgsql, libpgperl (postgresql specific),
libdbi-perl, couldn't find libdbi-pgsql however, someone should create this).

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M.Boekhold@et.tudelft.nl |
-----------------------------------------------------------------------------