Thread: DBI/DBD-Pg/perl question
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 -----------------------------/
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 |
-----------------------------------------------------------------------------