[Dspace-tech] Problem with scripts after PostGreSQL upgrade
Hi...
I just upgraded from PostGReSQL 7.2.3 to 8.3 (I am using DSpace 1.4.2).
I have a number of PERL scripts that I run that get data from the
PostGreSQL database. These scripts use the DBI connect command:
$dbh = DBI->connect('DBI:Pg:dbname=dspace', 'x', '');
This worked under the old PostGreSQL but under the new one, I get this error:
install_driver(Pg) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBD/Pg/Pg.so' for
module DBD::Pg: ld.so.1: list_users.pl: fatal: libpq.so.2: open failed:
Do I need to get new libraries for the new PostGreSQL?
George Kozak
Coordinator
Web Development and Management
Digital Media Group
501 Olin Library
Cornell University 14853
[EMAIL PROTECTED]
607-255-8924
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Problem with scripts after PostGreSQL upgrade
You need the libraries for 8.3 (and possibly you will have to rebuild the
DBD::Pg against these, I'm not sure. At least you have to have the
libraries).
**
Urban Andersson
Digital library
University of Gothenburg
Sweden
> Hi...
>
> I just upgraded from PostGReSQL 7.2.3 to 8.3 (I am using DSpace 1.4.2).
>
> I have a number of PERL scripts that I run that get data from the
> PostGreSQL database. These scripts use the DBI connect command:
> $dbh = DBI->connect('DBI:Pg:dbname=dspace', 'x', '');
>
> This worked under the old PostGreSQL but under the new one, I get this
> error:
>
> install_driver(Pg) failed: Can't load
> '/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBD/Pg/Pg.so' for
> module DBD::Pg: ld.so.1: list_users.pl: fatal: libpq.so.2: open failed:
>
> Do I need to get new libraries for the new PostGreSQL?
>
> George Kozak
> Coordinator
> Web Development and Management
> Digital Media Group
> 501 Olin Library
> Cornell University 14853
> [EMAIL PROTECTED]
> 607-255-8924
>
>
> -
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Problem with scripts after PostGreSQL upgrade
Hi, Everyone... In case anyone is wondering, I fixed my problem with PERL scripts after I upgraded to PostGreSQL 8.3, but discovered that the latest DBD::Pg Perl Module (DBD-Pg-2.2.1) doesn't work with my scripts. It looks as if they changed the way that variables are addressed in the latest version of DBD::Pg. After a of couple of days of messing around with it, I installed DBD-Pg-1.49 and everything worked fine. *** George Kozak Coordinator Web Development and Management Digital Media Group 501 Olin Library Cornell University 607-255-8924 *** [EMAIL PROTECTED] - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
