pg_dump: how to install on Amazon Linux for PostgreSQL 9.5.2?

Question

I used to install and do:

$ sudo yum install -y postgresql94-server postgresql94
$ pg_dump -h name-of-db.us-east-1.rds.amazonaws.com -U user dbName > dump

After RDS upgrade to 9.5.2 I get this:

pg_dump: server version: 9.5.2; pg_dump version: 9.4.5
pg_dump: aborting because of server version mismatch

I can't find a proper package for Amazon Linux

Can you?

score 23 · Answer 1 · edited Oct 14 '16 at 06:59

23

Ok, found it.

(1) Install the repo:

$ sudo rpm -Uvh https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-ami201503-95-9.5-3.noarch.rpm

- Update: 9.5.2-> 9.5.3 Found the repo here.

(2) Then install the package:

$ sudo yum install postgresql95

Now you can dump your RDS database to a near by ec2 instance!

edited Oct 14 '16 at 06:59

Aeramor

answered Apr 27 '16 at 11:26

Amir Mehler

In order for me to get this to work I first copied the proper link from https://yum.postgresql.org/repopackages.php. Then I had to uninstall my existing postgres `sudo yum remove postgresql92` before installing the new one. – McLovin Jul 04 '17 at 20:44

score 23 · Answer 2 · answered Feb 12 '19 at 20:10

23

I needed Postgres 10, so for me the command was:

sudo amazon-linux-extras install postgresql10

You can view a list of extras Amazon Linux provides by using this command:

amazon-linux-extras list

answered Feb 12 '19 at 20:10

postalservice14

2

amazon-linux-extras is available fro Amazon Linux 2 only – antiplayer Jun 12 '19 at 12:36
4

Thanks! For Postgres 11, simply change to `sudo amazon-linux-extras install postgresql11` – Aamir Feb 18 '21 at 23:37
I know it is super late, but this became useful for me and might come in handly for others -> sudo amazon-linux-extras install postgresql11 (just now :) ) – Vivek Raveendran Jun 17 '22 at 19:45

2 Answers2