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