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?
Add a comment |
2 Answers
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.
- 1Quite likely you'll need to do that as root: sudo rpm -i download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/…Vic Colborn– Vic Colborn2017-07-23 21:54:00 +00:00Commented Jul 23, 2017 at 21:54
- @Vic: That's quite clearly not the problem.Sven– Sven2017-07-23 21:59:21 +00:00Commented Jul 23, 2017 at 21:59
- Your answer is correct though, as I followed along, I needed to be root. It was the problem for me, and then your instructions were applicable.Vic Colborn– Vic Colborn2017-07-23 22:54:04 +00:00Commented Jul 23, 2017 at 22:54
Based on Sven's answer (with Vic's comment), you should:
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.rpmInstall the needed Postgresql 9.6 packages using yum
sudo yum install postgresql96-server.x86_64This would allow you to install a PostgreSQL server and create a
postgresuser. 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_64Which 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.
