Project ID: 76242


Babelfish for PostgreSQL RPM packages for EL 7, 8, 9 and Fedora.

EL packages are built against RHEL + EPEL (for EL 8 and 9) and against CentOS + EPEL (for 7), they are expected to be compatible with all popular EL derivatives.

Packages are based on postgresql Fedora package, source tarballs are fetched from GitHub tags ([1], [2]) and from Fedora lookaside cache, spec files and patches are stored on GitHub.

Latest packaged version: Babelfish 3.1 for PostgreSQL 15.2.

Installation Instructions

Install on EL 7 (CentOS example):

$ cat /etc/redhat-release CentOS Linux release 7.9.2009 (Core) $ sudo yum install yum-plugin-copr $ sudo yum copr enable wilton/babelfish-for-postgresql $ sudo yum update $ sudo yum install babelfishpg

Install on EL 8, EL 9 or Fedora (Rocky Linux example):

$ cat /etc/redhat-release Rocky Linux release 8.7 (Green Obsidian) $ sudo dnf copr enable wilton/babelfish-for-postgresql $ sudo dnf update $ sudo dnf install babelfishpg

Create DB and initialize Babelfish:

"postgresql" RPM packages in EL/Fedora use postgresql-setup script to create PostgeSQL DB cluster.

This package includes a modified version of "postgresql-setup" that additionally:

  • enables preloading of the Babelfish TDS library
  • enables "md5" password auth for localhost TCP connections
  • generates self-signed certificate and enables SSL
  • creates DB user and a database
  • initializes Babelfish extensions in this database using multi-db mode
$ sudo postgresql-setup --initdb --unit postgresql * Initializing database in '/var/lib/pgsql/data' * Initialized, logs are in /var/lib/pgsql/initdb_postgresql.log * Initializing Babelfish extensions ... * Babelfish initialization complete, use 'systemctl start postgresql' to start the server * ODBC connection: * DRIVER={ODBC Driver 18 for SQL Server};SERVER=,1433;UID=babelfish;PWD=babelfish;TrustServerCertificate=yes * JDBC connection with mssql-jdbc: * jdbc:sqlserver://;encrypt=true;trustServerCertificate=true WARNING: DB superuser 'babelfish' was created with password 'babelfish', please change the password before allowing remote connections.

Connect to Babelfish:

Connect to DB over TDS port 1433 using mssql-jdbc driver and sqlline command-line SQL client:

$ sudo systemctl start postgresql $ sudo dnf install java-openjdk $ curl -LO https://github.com/microsoft/mssql-jdbc/releases/download/v11.2.2/mssql-jdbc-11.2.2.jre8.jar $ curl -L https://search.maven.org/remotecontent?filepath=sqlline/sqlline/1.12.0/sqlline-1.12.0-jar-with-dependencies.jar -o sqlline-1.12.0-jar-with-dependencies.jar $ java -cp sqlline-1.12.0-jar-with-dependencies.jar:mssql-jdbc-11.2.2.jre8.jar sqlline.SqlLine --outputformat=vertical > !connect jdbc:sqlserver://;encrypt=true;trustServerCertificate=true babelfish babelfish > select @@version; version Babelfish for PostgreSQL with SQL Server Compatibility - 12.0.2000.8 May 9 2023 00:00:00 Copyright (c) Amazon Web Services PostgreSQL 15.2 on x86_64-redhat-linux-gnu (Babelfish 3.1.0)

Active Releases

The following unofficial repositories are provided as-is by owner of this project. Contact the owner directly for bugs or issues (IE: not bugzilla).

Release Architectures Repo Download
EPEL 7 x86_64 (316)* EPEL 7 (14 downloads)
EPEL 8 x86_64 (170)* EPEL 8 (14 downloads)
EPEL 9 x86_64 (189)* EPEL 9 (11 downloads)
Fedora 36 x86_64 (336)* Fedora 36 (0 downloads)
Fedora 37 x86_64 (100)* Fedora 37 (10 downloads)
Fedora 38 x86_64 (33)* Fedora 38 (5 downloads)
Fedora rawhide x86_64 (110)* Fedora rawhide (17 downloads)

* Total number of packages downloaded in the last seven days.