在AWS-EC2上安装PostgreSQL9.6

Question

我必须将特定版本的Postgresql安装到AWS-EC2实例中。我遵循了教程:设置PostgreSQ。

在过去，我按照教程做的，它的工作非常好。这一次，由于我需要9.6版本，我稍微扭曲了一下：

$ sudo yum install postgresql96 postgresql96-server postgresql96-devel postgresql96-contrib postgresql96-docs

装置运转良好。我现在正在尝试恢复设置：

sudo postgresql-setup initdb

并得到以下错误：

$ sudo postgresql-setup initdb
sudo: postgresql-setup: command not found

我也尝试了以下仅仅是为了它。

$ sudo postgresql96-setup initdb
sudo: postgresql96-setup: command not found



$ ls -ila /etc/rc.d/init.d
total 264
393352 drwxr-xr-x  2 root root  4096 Nov  5 08:25 .
393347 drwxr-xr-x 10 root root  4096 Aug 26 18:05 ..
393961 -rwxr-xr-x  1 root root  1729 Mar 27  2017 acpid
394280 -rwxr-xr-x  1 root root  2062 Aug 16  2016 atd
394415 -rwxr-xr-x  1 root root  3448 Mar  8  2017 auditd
394323 -r-xr-xr-x  1 root root  1362 Mar 30  2017 blk-availability
394399 lrwxrwxrwx  1 root root    46 Aug 26 18:05 cfn-hup -> /opt/aws/apitools/cfn-init/init/redhat/cfn-hup
393935 -rwxr-xr-x  1 root root  5160 Feb 28  2014 cgconfig
393936 -rwxr-xr-x  1 root root  3580 Feb 28  2014 cgred
394243 -rwxr-xr-x  1 root root  3782 Oct  4  2018 cloud-config
394244 -rwxr-xr-x  1 root root  3763 Oct  4  2018 cloud-final
394245 -rwxr-xr-x  1 root root  3855 Oct  4  2018 cloud-init
394246 -rwxr-xr-x  1 root root  3840 Oct  4  2018 cloud-init-local
394058 -rwxr-xr-x  1 root root  2826 Sep 28  2016 crond
393819 -rw-r--r--  1 root root 25651 Aug 17  2017 functions
393820 -rwxr-xr-x  1 root root  6037 Aug 17  2017 halt
394186 -rwxr-xr-x  1 root root  1395 Dec 13  2017 hibagent
394131 -rwxr-xr-x  1 root root  2267 Nov 12  2018 hibinit-agent
393401 -rwxr-xr-x  1 root root  8563 Sep 27  2013 ip6tables
393402 -rwxr-xr-x  1 root root  8468 Sep 27  2013 iptables
394156 -rwxr-xr-x  1 root root  1955 Oct 29  2018 irqbalance
393821 -rwxr-xr-x  1 root root   652 Jan 18  2017 killall
394324 -r-xr-xr-x  1 root root  2137 Mar 30  2017 lvm2-lvmetad
394325 -r-xr-xr-x  1 root root  2274 Mar 30  2017 lvm2-lvmpolld
394326 -r-xr-xr-x  1 root root  3045 Mar 30  2017 lvm2-monitor
394211 -rwxr-xr-x  1 root root  2904 Sep 18  2014 mdmonitor
394195 -rwxr-xr-x  1 root root  2200 Jul  2 17:59 messagebus
393822 -rwxr-xr-x  1 root root  4334 Jan 18  2017 netconsole
393823 -rwxr-xr-x  1 root root  5309 Jan 18  2017 netfs
393824 -rwxr-xr-x  1 root root  6742 Aug 17  2017 network
394003 -rwxr-xr-x  1 root root  6703 Oct  8  2015 nfs
394074 -rwxr-xr-x  1 root root  3526 Oct  8  2015 nfslock
394152 -rwxr-xr-x  1 root root  1926 May  3  2019 ntpd
393919 -rwxr-xr-x  1 root root  2049 May  3  2019 ntpdate
394548 -rwxr-xr-x  1 root root  7949 Dec  4  2018 postgresql96
394426 -rwxr-xr-x  1 root root  1556 Sep 10  2014 psacct
393778 -rwxr-xr-x  1 root root  2034 Sep 27  2013 quota_nld
393748 -rwxr-xr-x  1 root root  1515 May 17  2016 rdisc
394296 -rwxr-xr-x  1 root root  1816 Aug 17  2017 rngd
393273 -rwxr-xr-x  1 root root  2073 May  9  2018 rpcbind
394082 -rwxr-xr-x  1 root root  2518 Oct  8  2015 rpcgssd
394084 -rwxr-xr-x  1 root root  2305 Oct  8  2015 rpcidmapd
394087 -rwxr-xr-x  1 root root  2464 Oct  8  2015 rpcsvcgssd
393972 -rwxr-xr-x  1 root root  2011 Nov 11  2014 rsyslog
393643 -rwxr-xr-x  1 root root  2056 Sep 10  2014 saslauthd
394014 -rwxr-xr-x  1 root root  3702 Aug 17  2016 sendmail
393825 -rwxr-xr-x  1 root root   647 Jan 18  2017 single
394647 -rwxr-xr-x  1 root root  4180 Oct 23 23:47 sshd
393639 -rwxr-xr-x  1 root root  1642 Mar 19  2014 udev-post

Answer 1

Amazon Linux不适合PostgreSQL 9.6或需要额外的无文档定制安装步骤的可能性很大。

要安装像PostgreSQL这样的特定版本的服务，最简单的方法(可能是新标准)是使用Docker (和docker-compose)。

因此，(几乎)不管您使用的Linux发行版是什么：

• sudo yum install docker然后是sudo service docker start ( Amazon或其他Linux发行版的扩展文档)
• 然后安装码头工
• 找到一个用于docker-compose.yml文件的PostgreSQL示例，有很多。只需确保图像参数设置为image: "postgres:9.6"
• docker-compose up和你应该都准备好了