Question:
I need to use pg_dump for postgres 10.4 on my EC2 instance. My AMI version is:
$ cat /etc/system-release
Amazon Linux AMI release 2018.03
I’ve tried to get it from this repo: https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-2.noarch.rpm, then install postgres tools by command sudo yum install postgres10 but it works only for Amazon Linux 2.
Do you have any idea how can I get Postgres10 for my instance?
Answer:
I haven’t been able to find any existing packages for version 10, here is how I compiled the client tools myself on the 2018.03 AMI
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
sudo yum install -y gcc readline-devel zlib-devel wget https://ftp.postgresql.org/pub/source/v10.4/postgresql-10.4.tar.gz tar -xf postgresql-10.4.tar.gz cd postgresql-10.4 ./configure make -C src/bin sudo make -C src/bin install make -C src/include sudo make -C src/include install make -C src/interfaces sudo make -C src/interfaces install make -C doc sudo make -C doc install |
After this you can run pg_dump from /usr/local/pgsql/bin/pg_dump or alternatively add /usr/local/pgsql/bin to your PATH to run pg_dump anywhere