Babelfish for PostgreSQL在centos8下的安装说明

mkdir $HOME/babelfish-for-postgresql
cd $HOME/babelfish-for-postgresql
git clone https://github.com/babelfish-for-postgresql/postgresql_modified_for_babelfish.git
git clone https://github.com/babelfish-for-postgresql/babelfish_extensions.git

Flex 2.6.4
Libxml2 development libraries
Open SSL development libraries
Readline development libraries
Zlib
OSSP uuid development libraries
pkg-config
ICU development libraries
Bison 3.0.5 or higher

sudo yum install  build-essential flex libxml2-dev bison libreadline-dev zlib1g-dev
sudo yum install  uuid-dev pkg-config libossp-uuid-dev libssl-dev icu-devtools

[appstream]
name=CentOS Linux $releasever - AppStream
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=AppStream&infra=$infra
baseurl=https://mirrors.aliyun.com/centos/8-stream/AppStream/x86_64/os/
gpgcheck=1
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial

[baseos]
name=CentOS Linux $releasever - BaseOS
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=BaseOS&infra=$infra
baseurl=https://mirrors.aliyun.com/centos/8-stream/BaseOS/x86_64/os/
gpgcheck=1
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial

#查看有哪些组安装包可用
yum grouplist | more


#搜索一下有哪些和 Development 有关
 yum grouplist | grep Development


#安装Development Tools这个包
yum groupinstall -y "Development Tools"

  ./configure CFLAGS="-ggdb" \
  --prefix=/usr/local/pgsql \
  --enable-debug \
  --with-libxml \
  --with-uuid=ossp \
  --with-icu \
  --with-extra-version=" Babelfish for PostgreSQL"

#INSTALLATION_PATH=<the path you specified as prefix>
INSTALLATION_PATH=/usr/local/pgsql
mkdir "$INSTALLATION_PATH"

#sudo chown -R <your user>:<your group> "$INSTALLATION_PATH"
sudo chown -R guanhongchao:guanhongchao /usr/local/pgsql

cd $HOME/babelfish-for-postgresql/postgresql_modified_for_babelfish


make            # Compiles the Babefish for PostgreSQL engine
cd contrib 


make            # Compiles the PostgreSQL default extensions
cd ..


make install    # Installs the Babelfish for PostgreSQL engine
cd contrib


make install    # Installs the PostgreSQL default extensions

#源码编译后，pg_config存在的路径
export PG_CONFIG=/usr/local/pgsql/bin/pg_config


#postgresql_modified_for_babelfish源代码所在的路径
export PG_SRC=$HOME/babelfish-for-postgresql/postgresql_modified_for_babelfish


#cmake安装的路径
export cmake=/usr/local/cmake

Antlr 4.9.3 Runtime
Open Java 8
Unzip
pkgconf
libutfcpp development libraries
CMake

# unzip libutfcpp-dev cmake curl安装
sudo yum install  unzip libutfcpp-dev cmake curl


#Open Java 8 安装
sudo yum search jdk
sudo yum install java-1.8.0-openjdk 
sudo yum install java-1.8.0-openjdk-devel


# Antlr4 4.9.3 Runtime 安装
# Dowloads the compressed Antlr4 Runtime sources on opt/antlr4-cpp-runtime-4.9.3-source.zip 
sudo curl https://www.antlr.org/download/antlr4-cpp-runtime-4.9.3-source.zip \
  --output opt/antlr4-cpp-runtime-4.9.3-source.zip 




# Uncompress the source into opt/antlr4
sudo unzip -d opt/antlr4 opt/antlr4-cpp-runtime-4.9.3-source.zip


sudo mkdir opt/antlr4/build 
cd /opt/antlr4/build


#EXTENSIONS_SOURCE_CODE_PATH="<the patch in which you downloaded the Babelfish extensions source code>"
EXTENSIONS_SOURCE_CODE_PATH=$HOME/babelfish-for-postgresql/babelfish_extensions


# Generates the make files for the build
sudo cmake .. -DANTLR_JAR_LOCATION="$EXTENSIONS_SOURCE_CODE_PATH/contrib/babelfishpg_tsql/antlr/thirdparty/antlr/antlr-4.9.3-complete.jar" \
         -DCMAKE_INSTALL_PREFIX=/usr/local -DWITH_DEMO=True
# Compile and install
sudo make
sudo make install


sudo cp /usr/local/lib/libantlr4-runtime.so.4.9.3 "$INSTALLATION_PATH/lib"

#进入Babelfish extension 源码安装目录
cd $EXTENSIONS_SOURCE_CODE_PATH
# Install babelfishpg_money extension
cd contrib/babelfishpg_money
make
make install


# Install babelfishpg_common extension
cd ../babelfishpg_common
make 
make install


# Install babelfishpg_tds extension
cd ../babelfishpg_tds
make 
make install


# Installs the babelfishpg_tsql extension
cd ../babelfishpg_tsql
make 
make install

sudo mkdir -p usr/local/pgsql/data

sudo adduser postgres

sudo chown -R postgres:postgres $INSTALLATION_PATH
sudo chown -R postgres:postgres /usr/local/pgsql/data

sudo su postgres
$INSTALLATION_PATH/bin/initdb -D /usr/local/pgsql/data

listen_addresses = '*'
shared_preload_libraries = 'babelfishpg_tds'

$INSTALLATION_PATH/bin/pg_ctl -D /usr/local/pgsql/data start

$INSTALLATION_PATH/bin/psql

/* Create a user that will own the sample database */
CREATE USER babelfish_user WITH CREATEDB 


#CREATEROLE PASSWORD '<PUT_SECRET_PASSWORD_HERE>' INHERIT;
CREATEROLE PASSWORD '12345678' INHERIT;


/* Create a database named demo, owned by the above user */
CREATE DATABASE demo OWNER babelfish_user;
ALTER SYSTEM SET babelfishpg_tsql.database_name = 'demo';
SELECT pg_reload_conf();


/* Specify the migration mode for the database */
ALTER DATABASE demo SET babelfishpg_tsql.migration_mode = 'multi-db';


/* Move into the demo database */
\c demo


/* Create the extension in the demo database and initialize Babelfish */
CREATE EXTENSION IF NOT EXISTS "babelfishpg_tds" CASCADE;
CALL SYS.INITIALIZE_BABELFISH('babelfish_user');

# IPv4 local connections:
host    all             all             127.0.0.1/32            TRUST
host    all             all             10.16.6.9/32            TRUST