Re: Trouble installing postgresql server on Amazon Linux

Thanks for the reply. Yes, it seems that you're right about having
multiple pgdg93 repos,.

# yum repolist
Loaded plugins: priorities, update-motd, upgrade-helper
Repository pgdg93 is listed more than once in the configuration
Repository pgdg93-source is listed more than once in the configuration
8 packages excluded due to repository priority protections
repo id repo name
status
!amzn-main/latest amzn-main-Base
5,443+50
!amzn-updates/latest amzn-updates-Base
692+48
percona-release-noarch/latest Percona-Release YUM repository -
n 37
percona-release-x86_64/latest/x86_64 Percona-Release YUM repository - x
724+4
pgdg93/x86_64 PostgreSQL 9.3 - Amazon Linux AMI
284+4
repolist: 7,180

Can you suggest how I can go about removing the duplicate?
# ls -l /etc/yum.repos.d /etc/yum.repos.d
/etc/yum.repos.d:
total 36
-rw-r--r-- 1 root root 696 Feb 2 17:52 amzn-main.repo
-rw-r--r-- 1 root root 328 Sep 16 00:48 amzn-nosrc.repo
-rw-r--r-- 1 root root 694 Sep 16 00:48 amzn-preview.repo
-rw-r--r-- 1 root root 714 Feb 2 17:52 amzn-updates.repo
-rw-r--r-- 1 root root 957 Mar 1 2013 epel.repo
-rw-r--r-- 1 root root 1056 Mar 1 2013 epel-testing.repo
-rw-r--r-- 1 root root 2501 Sep 22 2014 percona-release.repo
-rw-r--r-- 1 root root 490 Oct 21 09:07 pgdg-93-ami201503.repo
-rw-r--r-- 1 root root 442 May 8 2013 pgdg-93-redhat.repo

... In fact, it seems like both of them must be the wrong repos? So I need
to remove these?
# rpm -e pgdg-93-redhat.repo
error: package pgdg-93-redhat.repo is not installed
# rpm -e pgdg-93-ami201503.repo
error: package pgdg-93-ami201503.repo is not installed

On Sun, Feb 7, 2016 at 2:52 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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(dot)klaver(at)aklaver(dot)com
>