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

[Yamil Suarez]

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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20151023/189422ba/attachment.html>