# mssql > 固定使用 PostgreSQL 17 兼容 Babelfish 内核，提供 SQL Server 协议与 T-SQL 兼容能力 --- LLMS 索引： [llms.txt](/zh/llms.txt) --- `mssql` 配置模板使用 **PostgreSQL 17 兼容的 Babelfish** 内核替代原生 PostgreSQL，提供 Microsoft SQL Server 线缆协议（TDS）与 T-SQL 语法兼容能力。当前模板固定 `pg_version: 17`；`configure` 不会用 `-v` 覆盖此固定内核版本。 从 Pigsty v4.2 以来，Babelfish 由 Pigsty 直接构建，不再使用 WiltonDB 仓库，可在所有 [支持的 Linux 平台](/docs/ref/linux) 上使用。 完整教程请参考：**[Babelfish (MSSQL) 内核使用说明](/docs/pgsql/kernel/babelfish/)** -------- ## 配置概览 - 配置名称： `mssql` - 节点数量： 单节点 - 配置说明：Babelfish（PG17）配置模板，提供 SQL Server 协议兼容 - 适用系统：`el8`, `el9`, `el10`, `d12`, `d13`, `u22`, `u24`, `u26` - 适用架构：`x86_64`, `aarch64` - 相关配置：[`meta`](/docs/conf/meta/) 启用方式： ```bash ./configure -c mssql [-i ] ``` -------- ## 配置内容 源文件地址：[`pigsty/conf/mssql.yml`](https://github.com/pgsty/pigsty/blob/main/conf/mssql.yml) ```yaml --- #==============================================================# # File : mssql.yml # Desc : Babelfish (MSSQL Wire-Compatible) template # Ctime : 2020-08-01 # Mtime : 2026-07-08 # Docs : https://pigsty.io/docs/conf/mssql # License : Apache-2.0 @ https://pigsty.io/docs/about/license/ # Copyright : 2018-2026 Ruohang Feng / Vonng (rh@vonng.com) #==============================================================# # This is the config template for Babelfish Kernel made by Pigsty # Which is a PostgreSQL 17/18 fork with SQL Server Compatibility # tutorial: https://pigsty.io/docs/pgsql/kernel/babelfish # # Usage: # curl https://repo.pigsty.io/get | bash # ./configure -c mssql [-v 17/18] # ./deploy.yml all: children: infra: { hosts: { 10.10.10.10: { infra_seq: 1 }} ,vars: { repo_enabled: false }} etcd: { hosts: { 10.10.10.10: { etcd_seq: 1 }} ,vars: { etcd_cluster: etcd }} #minio: { hosts: { 10.10.10.10: { minio_seq: 1 }} ,vars: { minio_cluster: minio }} #----------------------------------------------# # Babelfish Database Cluster #----------------------------------------------# pg-meta: hosts: 10.10.10.10: { pg_seq: 1, pg_role: primary } vars: pg_cluster: pg-meta pg_users: - {name: dbuser_mssql ,password: DBUser.MSSQL ,superuser: true, pgbouncer: true ,roles: [dbrole_admin], comment: superuser & owner for babelfish } pg_databases: - name: mssql baseline: mssql.sql extensions: [uuid-ossp, babelfishpg_common, babelfishpg_tsql, babelfishpg_tds, babelfishpg_money ] owner: dbuser_mssql parameters: { 'babelfishpg_tsql.migration_mode' : 'multi-db' } comment: babelfish cluster, a MSSQL compatible pg cluster pg_crontab: # https://pigsty.io/docs/pgsql/admin/crontab - '00 01 * * * /pg/bin/pg-backup full' # Babelfish Ad Hoc Settings pg_mode: mssql # Microsoft SQL Server Compatible Mode pg_version: 17 pg_packages: [ babelfish, pgsql-common, sqlcmd ] pg_libs: 'babelfishpg_tds, pg_stat_statements, auto_explain' # preload Babelfish TDS listener pg_hba_rules: # https://pigsty.io/docs/pgsql/config/hba - { user: dbuser_mssql ,db: mssql ,addr: intra ,auth: md5 ,title: 'allow mssql dbsu intranet access' ,order: 525 } # <--- use md5 auth method for mssql user - { user: all ,db: all ,addr: intra ,auth: md5 ,title: 'everyone intranet access with md5 pwd' ,order: 800 } pg_default_services: # route primary & replica service to mssql port 1433 - { name: primary ,port: 5433 ,dest: 1433 ,check: /primary ,selector: "[]" } - { name: replica ,port: 5434 ,dest: 1433 ,check: /read-only ,selector: "[]" , backup: "[? pg_role == `primary` || pg_role == `offline` ]" } - { name: default ,port: 5436 ,dest: postgres ,check: /primary ,selector: "[]" } - { name: offline ,port: 5438 ,dest: postgres ,check: /replica ,selector: "[? pg_role == `offline` || pg_offline_query ]" , backup: "[? pg_role == `replica` && !pg_offline_query]" } vars: #----------------------------------------------# # INFRA : https://pigsty.io/docs/infra/param #----------------------------------------------# version: v4.5.0 # pigsty version string admin_ip: 10.10.10.10 # admin node ip address region: default # upstream mirror region: default,china,europe infra_portal: # infra services exposed via portal home : { domain: i.pigsty } # default domain name #----------------------------------------------# # NODE : https://pigsty.io/docs/node/param #----------------------------------------------# nodename_overwrite: false # do not overwrite node hostname on single node mode node_repo_modules: node,infra,pgsql # babelfish kernel is in the pgsql repo node_tune: oltp # node tuning specs: oltp,olap,tiny,crit #----------------------------------------------# # PGSQL : https://pigsty.io/docs/pgsql/param #----------------------------------------------# pg_version: 17 # Babelfish kernel is compatible with postgres 17 pg_conf: oltp.yml # pgsql tuning specs: {oltp,olap,tiny,crit}.yml #----------------------------------------------# # PASSWORD : https://pigsty.io/docs/setup/security/ #----------------------------------------------# grafana_admin_password: pigsty grafana_view_password: DBUser.Viewer pg_admin_password: DBUser.DBA pg_monitor_password: DBUser.Monitor pg_replication_password: DBUser.Replicator patroni_password: Patroni.API haproxy_admin_password: pigsty minio_secret_key: S3User.MinIO etcd_root_password: Etcd.Root ... ``` -------- ## 配置解读 `mssql` 模板让您可以使用 SQL Server Management Studio (SSMS) 或其他 SQL Server 客户端工具连接 PostgreSQL（Babelfish 协议层）。 **关键特性**： - 使用 TDS 协议（端口 1433），兼容 SQL Server 客户端 - 支持 T-SQL 语法，迁移成本低 - 保留 PostgreSQL 的 ACID 特性和扩展生态（当前模板底层为 PG17） - 支持 `multi-db` 和 `single-db` 两种迁移模式 - 默认包组为 `babelfish + pgsql-common + sqlcmd` - 默认创建扩展：`uuid-ossp`、`babelfishpg_common`、`babelfishpg_tsql`、`babelfishpg_tds`、`babelfishpg_money` - v4.2.0 起支持主流平台全覆盖（EL8/9/10、Debian 12/13、Ubuntu 22/24/26；`x86_64` / `aarch64`） **连接方式**： ```bash # 使用 sqlcmd 命令行工具 sqlcmd -S 10.10.10.10,1433 -U dbuser_mssql -P DBUser.MSSQL -d mssql # 使用 SSMS 或 Azure Data Studio # Server: 10.10.10.10,1433 # Authentication: SQL Server Authentication # Login: dbuser_mssql # Password: DBUser.MSSQL ``` **适用场景**： - 从 SQL Server 迁移到 PostgreSQL - 需要同时支持 SQL Server 和 PostgreSQL 客户端的应用 - 希望利用 PostgreSQL 生态同时保持 T-SQL 兼容性 **注意事项**： - 当前 `mssql` 模板固定使用 PostgreSQL 17 兼容内核；不要依赖 `-v` 切换该模板的大版本 - 默认迁移模式为 `multi-db`（`babelfishpg_tsql.migration_mode`），可按需改为 `single-db` - 部分 T-SQL 语法可能存在兼容性差异，请参考 Babelfish 兼容性文档 - 需要使用 `md5` 认证方式（而非 `scram-sha-256`）