Thread: Installing DBD::Pg module without Pg Database server
Installing DBD::Pg module without Pg Database server
From
samik@cae.wisc.edu (Samik Raychaudhuri)
Date:
Hi, I want to install and work with DBD::Pg module thorugh Perl in one machine, but the database server is installed in another machine. Can I install and work with the module in this case? Is there any requirement-list for that? Any pointer will be helpful. Thanks and regards. -Samik
It has been a while since I used Perl to interface with PostgreSQL, but I can guarantee you that it is possible to install DBD::Pg on one machine and access another machine running PostgreSQL. I still have several boxes that do precisely that. You need to install DBI and DBD::Pg. Check out CPAN for more information. Jason samik@cae.wisc.edu (Samik Raychaudhuri) writes: > Hi, > I want to install and work with DBD::Pg module thorugh Perl in one > machine, but the database server is installed in another machine. Can > I install and work with the module in this case? Is there any > requirement-list for that? > Any pointer will be helpful. > Thanks and regards. > -Samik > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Samik,
I've found that DBD::Pg wants to be built on a machine with the postgresql
devel stuff on it. My suggestion would be to build it on the machine that
has the db on it, and then just copy the .pm onto the other machines.
Thanks,
Peter Darley
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jason Earl
Sent: Monday, December 03, 2001 11:26 AM
To: Samik Raychaudhuri
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing DBD::Pg module without Pg Database
server
It has been a while since I used Perl to interface with PostgreSQL,
but I can guarantee you that it is possible to install DBD::Pg on one
machine and access another machine running PostgreSQL. I still have
several boxes that do precisely that.
You need to install DBI and DBD::Pg. Check out CPAN for more
information.
Jason
samik@cae.wisc.edu (Samik Raychaudhuri) writes:
> Hi,
> I want to install and work with DBD::Pg module thorugh Perl in one
> machine, but the database server is installed in another machine. Can
> I install and work with the module in this case? Is there any
> requirement-list for that?
> Any pointer will be helpful.
> Thanks and regards.
> -Samik
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Peter Darley wrote: > > Samik, > I've found that DBD::Pg wants to be built on a machine with > the postgresql > devel stuff on it. My suggestion would be to build it on the machine that > has the db on it, and then just copy the .pm onto the other machines. Yes, you need the client libraries on the machine to build it. If you're on win32 (and not under Cygwin) I've heard this can be a challenge. There's a win32 binary available from the author of the module. If you continue having troubles there's also the dbi-users list.
>>>>> "a" == arguile <arguile@lucentstudios.com> writes: a> Peter Darley wrote: >> >> Samik, >> I've found that DBD::Pg wants to be built on a machine with >> the postgresql >> devel stuff on it. My suggestion would be to build it on the machine that >> has the db on it, and then just copy the .pm onto the other machines. That wouldn't work anyway, since the .pm just pulls in the shared object. If it were just a .pm file, then you wouldn't need to build anything. a> Yes, you need the client libraries on the machine to build it. The INSTALL file for postgres identifies how to install just the client parts onto a machine. If you follow that, and copy the postgres_ext.h file which is required by the other includes, you can build any other client program. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
Vivek,
I'm not absolutely sure about this, but I believe that I built the .pm on
one machine and copied it to my other machines that didn't have any
Postgresql stuff installed on them.
Thanks,
Peter Darley
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Vivek Khera
Sent: Tuesday, December 04, 2001 12:02 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing DBD::Pg module without Pg Database
server
>> My suggestion would be to build it on the machine that
>> has the db on it, and then just copy the .pm onto the other machines.
That wouldn't work anyway, since the .pm just pulls in the shared
object. If it were just a .pm file, then you wouldn't need to build
anything.
a> Yes, you need the client libraries on the machine to build it.
>>>>> "PD" == Peter Darley <pdarley@Kinesis-CEM.com> writes: PD> I'm not absolutely sure about this, but I believe that I built the .pm on PD> one machine and copied it to my other machines that didn't have any PD> Postgresql stuff installed on them. Not possible. Check out the .pm file. You'll see a "bootstrap" command from the DynaLoader system. That loads the corresponding .so file into perl. If you copied the .so, then maybe it would work if the .so pulls in the postgres client libs statically. If it references them dynamically, then you need to copy those as well, at which point you're having nearly the entire client environment there.
Hello, I have done as you have suggested (I understand I am following up pretty late :). It doesn't run. I guess it requires atleast 'Pg.so', which I don't have. Speciafically, my DB server is running on a Win2K. I want to run the perl scripts on a sun system, where I don't have enough permissions/quota to install/compile the Pg source code. I actually requested for this file from whoever is using my OS configuration (SunOS sun-80 5.8 Generic_108528-12 sun4u sparc SUNW,Sun-Blade-100). Any other suggestions? Thanks and regards. -Samik Peter Darley wrote: > Samik, > I've found that DBD::Pg wants to be built on a machine with the postgresql > devel stuff on it. My suggestion would be to build it on the machine that > has the db on it, and then just copy the .pm onto the other machines. > Thanks, > Peter Darley > > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jason Earl > Sent: Monday, December 03, 2001 11:26 AM > To: Samik Raychaudhuri > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Installing DBD::Pg module without Pg Database > server > > > > It has been a while since I used Perl to interface with PostgreSQL, > but I can guarantee you that it is possible to install DBD::Pg on one > machine and access another machine running PostgreSQL. I still have > several boxes that do precisely that. > > You need to install DBI and DBD::Pg. Check out CPAN for more > information. > > Jason > > samik@cae.wisc.edu (Samik Raychaudhuri) writes: > > >>Hi, >>I want to install and work with DBD::Pg module thorugh Perl in one >>machine, but the database server is installed in another machine. Can >>I install and work with the module in this case? Is there any >>requirement-list for that? >>Any pointer will be helpful. >>Thanks and regards. >>-Samik >>
Samik,
Umm... This is actually not good advice. As was pointed out later in this
thread, and as it looks like you know now you do need at least some of the
PG binaries. I hope this bad advice didn't cause you too many problems.
I suspect that you can get it working by compiling a subset of the PG code,
perhaps the client libraries only? Someone who knows more about this than I
might be able to answer that.
Thanks,
Peter Darley
-----Original Message-----
From: Samik Raychaudhuri [mailto:samik@cae.wisc.edu]
Sent: Thursday, February 14, 2002 11:33 PM
To: Peter Darley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing DBD::Pg module without Pg Database
server
Hello,
I have done as you have suggested (I understand I am following up pretty
late :). It doesn't run. I guess it requires atleast 'Pg.so', which I
don't have. Speciafically, my DB server is running on a Win2K. I want to
run the perl scripts on a sun system, where I don't have enough
permissions/quota to install/compile the Pg source code.
I actually requested for this file from whoever is using my OS
configuration (SunOS sun-80 5.8 Generic_108528-12 sun4u sparc
SUNW,Sun-Blade-100).
Any other suggestions?
Thanks and regards.
-Samik
Peter Darley wrote:
> Samik,
> I've found that DBD::Pg wants to be built on a machine with the
postgresql
> devel stuff on it. My suggestion would be to build it on the machine that
> has the db on it, and then just copy the .pm onto the other machines.
> Thanks,
> Peter Darley
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jason Earl
> Sent: Monday, December 03, 2001 11:26 AM
> To: Samik Raychaudhuri
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Installing DBD::Pg module without Pg Database
> server
>
>
>
> It has been a while since I used Perl to interface with PostgreSQL,
> but I can guarantee you that it is possible to install DBD::Pg on one
> machine and access another machine running PostgreSQL. I still have
> several boxes that do precisely that.
>
> You need to install DBI and DBD::Pg. Check out CPAN for more
> information.
>
> Jason
>
> samik@cae.wisc.edu (Samik Raychaudhuri) writes:
>
>
>>Hi,
>>I want to install and work with DBD::Pg module thorugh Perl in one
>>machine, but the database server is installed in another machine. Can
>>I install and work with the module in this case? Is there any
>>requirement-list for that?
>>Any pointer will be helpful.
>>Thanks and regards.
>>-Samik
>>