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

Re: Installing DBD::Pg module without Pg Database server

From
Jason Earl
Date:
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)

Re: Installing DBD::Pg module without Pg Database server

From
"Peter Darley"
Date:
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


Re: Installing DBD::Pg module without Pg Database server

From
"Arguile"
Date:
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.




Re: Installing DBD::Pg module without Pg Database server

From
Vivek Khera
Date:
>>>>> "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/

Re: Installing DBD::Pg module without Pg Database server

From
"Peter Darley"
Date:
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.


Re: Installing DBD::Pg module without Pg Database server

From
Vivek Khera
Date:
>>>>> "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.

Re: Installing DBD::Pg module without Pg Database server

From
Samik Raychaudhuri
Date:
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
>>



Re: Installing DBD::Pg module without Pg Database server

From
"Peter Darley"
Date:
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
>>