[OPEN-ILS-DEV] Need help with forcing the installation of PG 9.2.x with EG 2.7.5 (Debian Wheezy)

[Yamil Suarez]

Hello,

I think I am all set now. I just wanted to report back that I contacted
Blake (aka Bmagic) who had shown me the original approach to get PG 9.2
installed by default by EG 2.7.5.

Today Blake pointed this bug out...

Debian Jessie 2.8.0 libdbi-drivers cannot find libpq.so
https://bugs.launchpad.net/evergreen/+bug/1445182

I then followed Blake's suggestion to install the patch, created by
Josh Stompro, that fixes the bug, and the installation worked in
conjunction to Blake's original instructions for forcing PG 9.2.

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/stompro/lp1445182_jessie_libdbi_build

Thanks everyone,
Yamil



On Fri, Oct 23, 2015 at 12:04 PM, Yamil Suarez <ysuarez at berklee.edu> wrote:

> Jason (and others),
>
> Thanks for all the suggestions.
>
> At one point I did try installing PG 9.2 manually apt-get, but it was
> after I had already installed OSRF and I got some errors. Though I think it
> was because the PG targets were still there.
>
> My guess is that means removing/commenting out these sections from
> Evergreen/Open-ILS/src/extras/install/Makefile.wheezy? Anything else?
>
>
> --------------------
> PGSQL_SERVER_DEBS_91 = \
>     $(DEB_PGSQL_COMMON_MODS) \
>     postgresql-9.2 \
>     postgresql-contrib-9.2 \
>     postgresql-plperl-9.2 \
>     postgresql-server-dev-9.2
>
> <snip>
>
> install_postgres_server:
> make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_SERVER_DEBS_91)"
> ---------------------
>
>
> I will try installing PG before I do anything else to see how that goes.
>
> Also, good to know that you have had success with loading a newer PG
> version into an older version, at least for testing purposes. I had tried
> that originally, but I was scared away by the warning and a couple of
> errors that I got. I think the main issue I was expecting a different DB
> name in the 9.2 data dump.
>
> Thanks again,
> Yamil
>
>
>
>
>
>
> On Fri, Oct 23, 2015 at 11:37 AM, Jason Stephenson <jstephenson at mvlc.org>
> wrote:
>
>> Yamil,
>>
>> I have the following suggestions:
>>
>> Add the apt repository for PostgreSQL to your system.  You can
>> find instructions here: https://wiki.postgresql.org/wiki/Apt
>>
>> There should be a 9.2 server and so forth that you can install
>> from there.
>>
>> You will want to install that before installing OpenSRF,
>> Evergreen, or other prerequisites.
>>
>> As an alternative, loading the dump into a 9.1 database server
>> will probably work.  I load Evergreen dumps from 9.3 server into
>> a 9.1 server all the time.  I get lots of warnings, but in the
>> end the data loads and Evergreen still works.
>>
>> Hope that helps,
>>
>> Jason
>> --
>> Jason Stephenson
>> Assistant Director for Technology Services
>> Merrimack Valley Library Consortium
>> 4 High ST, Suite 175
>> North Andover, MA 01845
>> Phone: 978-557-5891
>> Email: jstephenson at mvlc.org
>>
>>
>>
>
>
>


-- 



--------------------------------

Yamil Suarez, MCS
Library System Administrator/Developer

Stan Getz Library
Berklee College of Music
1140 Boylston St
Boston, MA 02215

ysuarez at berklee.edu
617-747-2617
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20151026/97a1c9f1/attachment.html>