search

ihanick / anydbver

LXD+Ansible setup to install Percona/Oracle MySQL/MongoDB/Postgresql database products with exact version specified.
MIT License
50 stars 12 forks source link

Can you please add support for postgresql version 9.6 #16

Open jamesydb opened 1 year ago

jamesydb commented 1 year ago

Can you please add support for postgresql version 9.6

Thanks

ihanick commented 1 year ago

Hi @jamesydb , PG 9.6 was removed from pgdg repository: https://download.postgresql.org/pub/repos/yum/

Currently the only reliable way to install any version (probably only on el7 (RHEL7, centos 7, oracle linux 7)) could be only the Source method.

yum groupinstall -y 'Development Tools'
yum install -y wget
wget https://ftp.postgresql.org/pub/source/v9.6.24/postgresql-9.6.24.tar.bz2
cd /usr/local/src
tar -xaf ~/postgresql-9.6.24.tar.bz2 
cd postgresql-9.6.24/
yum install yum-utils
yum-builddep postgresql
./configure 
make all install
make install
groupadd postgres
useradd -m -g postgres postgres
sudo -u postgres -i
export PATH=/usr/local/pgsql/bin:$PATH
export PGDATA=$PWD/pgdata
initdb

Will it be valuable for you?

You can expect the following deployment command

./anydbver deploy pg:9.6,source
jamesydb commented 1 year ago

Thanks for your response. Really Appreciate.