From: Tom Lane <tgl@sss.pgh.pa.us>
To: Armin Resch <reschab@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Using pre-configured vs building Postgres
Date: Mon, 07 Jan 2013 13:37:27 -0500
Message-ID: <14096.1357583847@sss.pgh.pa.us> (raw)
In-Reply-To: <CAGo0LBTE3MU0cMrSMB+UF-z6rjasQiup_iRVaYusM=SvJ1eBeA@mail.gmail.com>
References: <CAGo0LBTE3MU0cMrSMB+UF-z6rjasQiup_iRVaYusM=SvJ1eBeA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Armin Resch <reschab@gmail.com> writes:
> Yet, now, we switch to a more modern distro (OpenSuse 12.1), which does
> have the RPM for Perl 5.14.2 pre-installed with the option to install more
> RPMs such as
> perl-DBI-1.616-7.1.3
> perl-DBD-Pg-2.18.0-3.1.4
> postgresql-9.1.1-3.1.4
> Once our custom applications are tested and behave, the idea is to freeze
> all prerequisites until we go to a different generation (potentially
> different distro altogether in >= 5 years).
> Before I try to obtain a handful of CPAN modules which are missing or
> 'unsupported' in OpenSuse, my question to this admin forum is what pro's
> and con's to consider when deciding whether to use a pre-configured
> postgresql versus building it ourselves.
Well, if you're starting deployment now with a five-year plan, it's
pretty dumb not to be using the latest major release (ie 9.2). 9.1
will be out of support in four years.
But even if 9.1 is the release series you want to freeze on, it does
not speak well at all for OpenSUSE's update practices if they're still
shipping 9.1.1. That's more than a year out of date, and has assorted
known security and data-loss issues, cf
http://www.postgresql.org/docs/9.1/static/release.html
If that's actually the latest version available from them, you'd be
very well advised to use your own build of PG instead, and pay attention
to our update releases.
I can't speak to the question of whether their Perl packages are equally
out of date --- you might be all right using those.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, reschab@gmail.com
Subject: Re: Using pre-configured vs building Postgres
In-Reply-To: <14096.1357583847@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox