Re: Trouble installing postgresql server on Amazon Linux

On 02/07/2016 11:18 AM, Augori wrote:
> Hello,
>
> I'm trying to install postgresql on an Amazon Linux AMI release
> 2015.09.  I got the rpm for Amazon Linux AMI 2015.03 - x86_64 under
> PostgreSQL 9.3 linked here:
> http://yum.postgresql.org/repopackages.php
>
> But a yum install  complains that it requires systemd-units, which I
> haven't figure out how to get.  The yum command and result:
>
> ]# yum -y install postgresql93 postgresql93-server postgresql93-contrib
> postgresql93-libs
> Loaded plugins: priorities, update-motd, upgrade-helper
> Repository pgdg93 is listed more than once in the configuration

The above seems to be part of the problem. Looks like you have two
repositories for pgdg93.

Are you sure the AMI did not already have a repo for Postgres?

> Repository pgdg93-source is listed more than once in the configuration
> 8 packages excluded due to repository priority protections
> Resolving Dependencies
> --> Running transaction check
> ---> Package postgresql93.x86_64 0:9.3.10-1PGDG.rhel7 will be installed

The above would seem to be the second problem and related to the first.
When I peeked into:

http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-ami201503-93-9.3-2.noarch.rpm

it showed that it was looking for:

https://download.postgresql.org/pub/repos/yum/9.3/redhat/rhel-6-$basearch


Seems you are trying to install a RH 7 package on an OS that is looking
for a RH 6 package. In other words yum is finding the RH 7 repo before
the RH 6 repo.


> ---> Package postgresql93-contrib.x86_64 0:9.3.10-1PGDG.rhel7 will be
> installed
> ---> Package postgresql93-libs.x86_64 0:9.3.10-1PGDG.rhel7 will be installed
> ---> Package postgresql93-server.x86_64 0:9.3.10-1PGDG.rhel7 will be
> installed
> --> Processing Dependency: systemd-units for package:
> postgresql93-server-9.3.10-1PGDG.rhel7.x86_64
> --> Processing Dependency: systemd-units for package:
> postgresql93-server-9.3.10-1PGDG.rhel7.x86_64
> --> Finished Dependency Resolution
> Error: Package: postgresql93-server-9.3.10-1PGDG.rhel7.x86_64 (pgdg93)
>             Requires: systemd-units
>   You could try using --skip-broken to work around the problem
>   You could try running: rpm -Va --nofiles --nodigest
>
> ----------------------------------------------------------------------------------------
>
> The --skip-broken option returns Errno 256
> # yum -y install --skip-broken postgresql93 postgresql93-server
> postgresql93-contrib postgresql93-libs
> .
> .
> .
> Error downloading packages:
>    postgresql93-contrib-9.3.10-1PGDG.rhel7.x86_64: failure:
> postgresql93-contrib-9.3.10-1PGDG.rhel7.x86_64.rpm from pgdg93: [Errno
> 256] No more mirrors to try.
>    postgresql93-9.3.10-1PGDG.rhel7.x86_64: failure:
> postgresql93-9.3.10-1PGDG.rhel7.x86_64.rpm from pgdg93: [Errno 256] No
> more mirrors to try.
>    postgresql93-libs-9.3.10-1PGDG.rhel7.x86_64: failure:
> postgresql93-libs-9.3.10-1PGDG.rhel7.x86_64.rpm from pgdg93: [Errno 256]
> No more mirrors to try.
>
>
> ----------------------------------------------------------------------------------------
>
> I've tried quite a few other things, but now I'm back to the same
> error.  Do you have any suggestions?
>
> Thank you,
> Augori


--
Adrian Klaver
adrian.klaver@aklaver.com