Babelfish
Babelfish is a PostgreSQL-based SQL Server compatibility layer, open-sourced by AWS.
Overview
Deploy Babelfish in mssql mode to add these features to PostgreSQL:
- SQL Server wire protocol compatibility (TDS,
1433) - T-SQL compatibility
- Unified integration with Pigsty capabilities (HA, backup, monitoring, IaC)
Pigsty provides Babelfish packages compatible with PostgreSQL 17/18. The current PG18 baseline is Babelfish 6.2.0 on PostgreSQL 18.6; the default conf/fork/mssql.yml template selects pg_version: 17. See the package list for platform availability.
./configure explicitly excludes fork/mssql and shorthand -c mssql from -v major-version overrides. To use PG18, generate pigsty.yml, manually set pg_version: 18, and verify target-platform packages. See the MSSQL template.
Quick Start
Use Pigsty’s fork/mssql template (conf/fork/mssql.yml); -c mssql and -c fork/mssql are equivalent:
After deployment, connect directly with SQL Server clients:
Key Configuration
Core parameters in the mssql template:
Connectivity and Ports
Babelfish clusters expose two protocol endpoints:
- PostgreSQL protocol:
5432 - SQL Server protocol (TDS):
1433
Through Pigsty services, you can also use these ports:
5433: fixed route to primary14335434: route to readable node1433
Notes
- Babelfish auth rules must use
md5instead of defaultscram-sha-256. - Default migration mode is
multi-db; switch withbabelfishpg_tsql.migration_modeif needed. - Some native PostgreSQL extensions cannot run directly on Babelfish kernels. Verify package availability and compatibility first.
- For production, restrict HBA rules and network access. Do not keep the open rules from the demonstration configuration.
Related Docs
Available Extensions
The table lists selected non-Contrib extensions for reference. Query the target instance to confirm actual availability and versions.
| Extension | Version | Description |
|---|---|---|
| babelfishpg_common | 5.4.0 | Transact SQL Datatype Support |
| babelfishpg_money | 1.1.0 | babelfishpg_money |
| babelfishpg_tds | 1.0.0 | TDS protocol extension |
| babelfishpg_tsql | 5.4.0 | Transact SQL compatibility |