Thread: PostgreSQL packages for Debian potato

PostgreSQL packages for Debian potato

From
Alessio Bragadini
Date:
We have a number of client machines running Debian Linux, "potato"
release (i.e. 2.2, latest stable). The provided PostgreSQL is release
6.5.3, but I managed to track changes in unstable ("woody") until 7.0.2,
as long as packages were built using an older glibc. Now, unstable
packages (of 7.0.3) are linked against a newer one and using them means
upgrading the whole system, or building from source, or breaking
dependencies, etc., all steps that I am not willing to take.

Sorry for this long dissertation about the Debian world-of-packages,
this is to explain why there aren't anymore, to my knowledge, .deb
packages easily installable on potato and I preciously keep a number of
packages knowing that I have no easy way to reobtain them. But I am
missing ecpg and I cannot install the one provided by Debian since it
carries a huge set of unsatisfied dependencies.

Q1: is there anyone out there with a ecpg_7.0.2-X_i386.deb available?
Q2: are there anywhere Debian potato packages of recent releases?

TIA

--
Alessio F. Bragadini        alessio@albourne.com
APL Financial Services        http://village.albourne.com
Nicosia, Cyprus             phone: +357-2-755750

"It is more complicated than you think"
        -- The Eighth Networking Truth from RFC 1925

Re: PostgreSQL packages for Debian potato

From
Doug McNaught
Date:
Alessio Bragadini <alessio@albourne.com> writes:

> Q1: is there anyone out there with a ecpg_7.0.2-X_i386.deb available?
> Q2: are there anywhere Debian potato packages of recent releases?

What's wrong with getting the source debs for 7.0.x and building them
on your Potato system?

-Doug

Re: PostgreSQL packages for Debian potato

From
jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Alessio Bragadini <alessio@albourne.com> wrote:
>We have a number of client machines running Debian Linux, "potato"
>release (i.e. 2.2, latest stable). The provided PostgreSQL is release
>6.5.3, but I managed to track changes in unstable ("woody") until 7.0.2,

I'd recommend against using "unstable" for client machines. If you need
something more up to date that "stable", use "testing" (although AFAIK it
doesn't have 7.0.x yet).

>as long as packages were built using an older glibc. Now, unstable packages
>(of 7.0.3) are linked against a newer one and using them means upgrading
>the whole system, or building from source, or breaking dependencies, etc.,
>all steps that I am not willing to take.

Rebuilding from source is a fairly straightforward process. I've done it to
get debs to use on some of our servers that run "stable".

>Q2: are there anywhere Debian potato packages of recent releases?

See http://www.internatif.org/brotzmeyer/debian/apt-sources/ .

HTH,
Ray
--
Ziff Davis is so obviously biased to Microsoft in almost everything they
publish, that they might as well change their company name to MS-PRAVDA.
    Darryl Householder commenting on extreme PC Week FUD
    (http://linuxtoday.com/story.php3?sn=21049&showcomments=flat)

Re: PostgreSQL packages for Debian potato

From
Alessio Bragadini
Date:
[Sorry for the late reply]

Doug McNaught wrote:

> What's wrong with getting the source debs for 7.0.x and building them
> on your Potato system?

Well, nothing per se, but first, personally I have little or no
experience to adapt a woody package to the potato structure, even if I
believe there is no much to do in 7.0.2->7.0.3. Yes, I am lazy and I
wanted to back up on some other people's work. :-)

More important, I wanted a general overview of the problem of "tracking
updated PostgreSQL packages while running Debian stable" because I
believe this can become quite a problem. Hopefully 7.1 will be out in a
few weeks, but in meantime Debian proposes 6.5.3 and woody won't become
stable for quite some months - and I am not even sure it will include
7.1. I wanted to know what is in the plans of other people who like to
run an updated version of PostgreSQL and in the meantime not to break
Debian system.

Thanks to everyone for their help.

--
Alessio F. Bragadini        alessio@albourne.com
APL Financial Services        http://village.albourne.com
Nicosia, Cyprus             phone: +357-2-755750

"It is more complicated than you think"
        -- The Eighth Networking Truth from RFC 1925

Re: PostgreSQL packages for Debian potato

From
will trillich
Date:
On Wed, Feb 28, 2001 at 02:59:26PM +0200, Alessio Bragadini wrote:
> [Sorry for the late reply]
>
> Doug McNaught wrote:
>
> > What's wrong with getting the source debs for 7.0.x and building them
> > on your Potato system?
>
> Well, nothing per se, but first, personally I have little or no
> experience to adapt a woody package to the potato structure, even if I
> believe there is no much to do in 7.0.2->7.0.3. Yes, I am lazy and I
> wanted to back up on some other people's work. :-)
>
> More important, I wanted a general overview of the problem of "tracking
> updated PostgreSQL packages while running Debian stable" because I
> believe this can become quite a problem. Hopefully 7.1 will be out in a
> few weeks, but in meantime Debian proposes 6.5.3 and woody won't become
> stable for quite some months - and I am not even sure it will include
> 7.1. I wanted to know what is in the plans of other people who like to
> run an updated version of PostgreSQL and in the meantime not to break
> Debian system.

hi, fellow debianmonger... :)

you may already know, but in case you don't, here's a
sources.list line for the 7.0.3 version of postgresql that's
potato-friendly:

    # postgresql 7.* -- for potato?
    deb http://www.samfundet.no/~tfheen/debian potato main

then

    apt-get update && apt-get upgrade

or, for completeness,

    % apt-get install postgresql-pl postgresql-dev
    % perl -MCPAN -e shell
    cpan> install DBD::Pg
    cpan> look DBD::Pg
    % setenv POSTGRESQL_LIB /usr/lib/postgresql/lib
    % setenv POSTGRESQL_INCLUDE /usr/include/postgresql
    % perl Makefile.PL
    % make
    % make install
    % ^D
    cpan> q
    %

you'll need to recompile DBD::Pg with the new postgresql-dev
headers so perl's $dbh=DBI->connect("dbi:Pg:dbname=something")
will work again.

i originally jumped on board 7.0.3potato because of the embedded
perl but it's not actually present; however, rules and triggers
and a host of other nice features make the jump worthwhile.
and built-in perl will show up soon, i'm confident.

just make SURE you get a healthy schema/data dump first, tho... :)

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
        -- Isaac Asimov, 'The Genetic Code'

will@serensoft.com
http://groups.yahoo.com/group/newbieDoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!