[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