Re: postgresql-10 for ubuntu-17.10 (artful)?

From: Stuart McGraw <smcgraw(at)mtneva(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql-10 for ubuntu-17.10 (artful)?
Date: 2017-12-27 20:13:39
Message-ID: 82d0d6dc-035b-e461-c8d0-60f6f4ed2623@mtneva.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/27/2017 11:07 AM, Steve Atkins wrote:
>> On Dec 26, 2017, at 6:21 PM, Stuart McGraw <smcg4191(at)mtneva(dot)com> wrote:
>> Is there a repository for Postgresql-10 available at
>> http://apt.postgresql.org/pub/repos/apt for Ubuntu-17.10 (artful)?
>> When I look at the dist/ subdirectory there, there seem to be repos
>> for all the other Ubuntu releases including an upcoming one
>> (bionic) but not artful.
>>
>> Am I looking in the wrong place? (I am new to Ubuntu and Debian
>> packaging.)
>
> I think that LTS releases (14.04, 16.04, 18.04) are the main releases
> targeted, with intermediate releases only added if they're
> incompatible with the previous LTS release.
>
> See the FAQ at https://wiki.postgresql.org/wiki/Apt/FAQ - I think
> you should be able to use the 17.04 package on 17.10.
>
> Cheers, Steve

Thanks. I added the 17.04 PGDG repository:
deb http://apt.postgresql.org/pub/repos/apt/ zesty-pgdg main
and postgresql-10 and friends installed ok. But later installing
a different package:

Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
postgresql-autodoc : Depends: libdbd-pg-perl but it is not going
to be installed
E: Unable to correct problems, you have held broken packages.

further,

# apt-get install libdbd-pg-perl
[... same message as from ansible except: ]
The following packages have unmet dependencies:
libdbd-pg-perl : Depends: perlapi-5.24.1 but it is not installable
# apt-get install perlapi
E: Unable to locate package perlapi

# apt show -a 'libdbd-pg-perl'
[...output abbreviated...]
Package: libdbd-pg-perl
Version: 3.7.0-1~pgdg17.04+1
Depends: perl (>= 5.24.1-2ubuntu1), perl-dbdabi-94, perlapi-5.24.1,
libc6 (>= 2.14), libpq5 (>= 8.4~), libdbi-perl (>= 1.614)

Package: libdbd-pg-perl
Version: 3.6.2-2build1
Depends: perl (>= 5.26.0-4), perl-dbdabi-94, perlapi-5.26.0,
libc6 (>= 2.14), libpq5 (>= 8.4~), libdbi-perl (>= 1.614)

As I said, I am new to Ubuntu packaging so whether the problem
is something I need to research elsewhere and fix, or if it is
an actual problem with the PGDG repository, is not clear to me.

(Yes, I realize
https://www.postgresql.org/download/linux/ubuntu/
says only LTS releases of Ubuntu are "fully" supported, but if
it just takes a minor fix to make things work with 17.10...)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2017-12-27 20:24:07 Re: Does PostgreSQL check database integrity at startup?
Previous Message Alvaro Herrera 2017-12-27 20:11:16 Re: Does PostgreSQL check database integrity at startup?