Skip to content

Instantly share code, notes, and snippets.

@eulerto
Created December 1, 2019 21:42
Show Gist options
  • Save eulerto/ed53eefecf2156b75765406321930214 to your computer and use it in GitHub Desktop.
Save eulerto/ed53eefecf2156b75765406321930214 to your computer and use it in GitHub Desktop.
--
-- CentOS
--
sudo yum update -y
sudo yum groupinstall "Development Tools"
sudo yum install -y cmake
--
-- go to https://yum.postgresql.org/repopackages.php
--
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
--
-- if it is CentOS 8, disable postgresql module
--
-- sudo dnf -qy module disable postgresql
sudo yum install postgresql94-devel postgresql95-devel postgresql96-devel postgresql10-devel postgresql11-devel postgresql12-devel
cd $HOME
git clone https://github.com/eulerto/pgquarrel.git
ln -s /usr/pgsql-9.4 pg94
ln -s /usr/pgsql-9.5 pg95
ln -s /usr/pgsql-9.6 pg96
ln -s /usr/pgsql-10 pg10
ln -s /usr/pgsql-11 pg11
ln -s /usr/pgsql-12 pg12
./test-pgquarrel.sh
--
-- Ubuntu
--
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install build-essential
sudo apt-get install cmake
--
-- go to https://wiki.postgresql.org/wiki/Apt
--
curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
--
-- replace "bionic" with your distribution codename
--
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
sudo apt-get update
sudo apt-get install postgresql-server-dev-9.3 postgresql-server-dev-9.4 postgresql-server-dev-9.5 postgresql-server-dev-9.6 postgresql-server-dev-10 postgresql-server-dev-11 postgresql-server-dev-12
cd $HOME
git clone https://github.com/eulerto/pgquarrel.git
ln -s /usr/lib/postgresql/9.3 pg93
ln -s /usr/lib/postgresql/9.4 pg94
ln -s /usr/lib/postgresql/9.5 pg95
ln -s /usr/lib/postgresql/9.6 pg96
ln -s /usr/lib/postgresql/10 pg10
ln -s /usr/lib/postgresql/11 pg11
ln -s /usr/lib/postgresql/12 pg12
./test-pgquarrel.sh
--
-- FreeBSD
--
pkg install git cmake gcc9
pkg install postgresql12-server
cd $HOME
git clone https://github.com/eulerto/pgquarrel.git
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment