importing older postgresql

importing_older_postgresql_data.sh

#mount large filesystem (200GB) onto /mnt/


setenforce  0


cd /mnt/
tar -xzf pgsql_data.tar.gz 

#link /var/lib/pgsql from /mnt
mv /var/lib/pgsql/ /var/lib/pgsql.bak
ln -s /mnt/var/lib/pgsql/ /var/lib/


# move scl postgresql to /mnt
mkdir -p  /mnt/var/opt/rh/rh-postgresql12/lib/
mv /var/opt/rh/rh-postgresql12/lib/pgsql/ /mnt/var/opt/rh/rh-postgresql12/
ln -s /mnt/var/opt/rh/rh-postgresql12/pgsql/ /var/opt/rh/rh-postgresql12/lib/
mv /var/opt/rh/rh-postgresql12/lib/pgsql/data /var/opt/rh/rh-postgresql12/lib/pgsql/data.bak

chown postgres:postgres /var/opt/ -R

rpm -e rh-postgresql12-postgresql-syspaths  rh-postgresql12-postgresql-server-syspaths
yum install postgresql-server.x86_64 


vi /etc/systemd/system/postgresql.service 
systemctl restart postgresql
systemctl status postgresql  #should be running
foreman-installer 

#optinoally remove pre-migrated db to save space
rm -rf /mnt/var/lib/pgsql/