12

What's the best way to install postgres-server 9.6 on Amazon Linux without building from source? I tried running rpm -i https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-ami201503-96-9.6-2.noarch.rpm to install the version listed on https://yum.postgresql.org/repopackages.php, and it installed without errors, but I still don't have service postgresql, or psql, or a postgres user. What did I miss?

shroud
  • 223

2 Answers2

13

You have installed the repository that makes PostgreSQL packages available (check /etc/yum.repos.d). Now you can do yum update and actually install the DB with yum install postgresql96-server.

Sven
  • 100,763
0

Based on Sven's answer (with Vic's comment), you should:

  1. Include the official PostgreSQL 9.6 RPM package file

    sudo rpm -i https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-ami201503-96-9.6-2.noarch.rpm

  2. Install the needed Postgresql 9.6 packages using yum

    sudo yum install postgresql96-server.x86_64

    This would allow you to install a PostgreSQL server and create a postgres user. However, since you've also wanted to install the command line tools for postgres, you will need...

    sudo yum install postgresql96.x86_64 postgresql96-libs.x86_64

    Which installs psql, pg_dump, and other command line tools.

I know it is too late but I hope that helps anyone who might stumble on this kind of problem.

Community
  • 1
Abel Melquiades Callejo
  • 187