Babelfish version updates - Amazon Aurora

Babelfish version updates

Babelfish is an option available with Aurora PostgreSQL version 13.4 and higher releases. Updates to Babelfish become available with certain new releases of the Aurora PostgreSQL database engine. For more information, see the Release Notes for Aurora PostgreSQL.

For a list of supported functionality across different Babelfish releases, see Supported functionality in Babelfish by version.

For a list of currently unsupported functionality, see Unsupported functionality in Babelfish.

Note

Currently, you can't upgrade Babelfish DB clusters running on Aurora PostgreSQL 13.7 or older versions to Aurora PostgreSQL 14.3 with Babelfish 2.1.0.

You can use the describe-db-engine-versions AWS CLI command to get a list of Aurora PostgreSQL versions in your AWS Region that support Babelfish, as shown in the following example.

For Linux, macOS, or Unix:

$ aws rds describe-db-engine-versions --region us-east-1 \ --engine aurora-postgresql \ --query '*[]|[?SupportsBabelfish==`true`].[EngineVersion]' \ --output text 13.4 13.5 13.6 13.7 14.3

For more information, see describe-db-engine-versions in the AWS CLI Command Reference.

Identifying your version of Babelfish

You can query Babelfish to find details about the Babelfish version, the Aurora PostgreSQL version, and the compatible Microsoft SQL Server version. You can use the TDS port or the PostgreSQL port.

To use the TDS port to query for version information

  1. Use sqlcmd or ssms to connect to the endpoint for your Babelfish DB cluster.

    sqlcmd -S bfish_db.cluster-123456789012.aws-region.rds.amazonaws.com,1433 -U login-id -P password -d db_name
  2. To identify the Babelfish version, run the following query:

    1> SELECT CAST(serverproperty('babelfishversion') AS VARCHAR) 2> GO

    The query returns results similar to the following:

    serverproperty ------------------------------ 2.1.0 (1 rows affected)
  3. To identify the version of the Aurora PostgreSQL DB cluster, run the following query:

    1> SELECT aurora_version() AS aurora_version 2> GO

    The query returns results similar to the following:

    aurora_version ------------------------------------------------- 14.3.0 (1 rows affected)
  4. To identify the compatible Microsoft SQL Server version, run the following query:

    1> SELECT @@VERSION AS version 2> GO

    The query returns results similar to the following:

    Babelfish for Aurora PostgreSQL with SQL Server Compatibility - 12.0.2000.8 May 23 2022 19:17:14 Copyright (c) Amazon Web Services PostgreSQL 14.3 on x86_64-pc-linux-gnu (1 rows affected)

As an example that shows one minor difference between Babelfish and Microsoft SQL Server, you can run the following query. On Babelfish, the query returns 1, while on Microsoft SQL Server, the query returns NULL.

SELECT CAST(serverproperty('babelfish') AS VARCHAR) AS runs_on_babelfish

You can also use the PostgreSQL port to obtain version information, as shown in the following procedure.

To use the PostgreSQL port to query for version information

  1. Use psql or pgAdmin to connect to the endpoint for your Babelfish DB cluster.

    psql host=bfish_db.cluster-123456789012.aws-region.rds.amazonaws.com port=5432 dbname=babelfish_db user=sa
  2. Turn on the extended feature (\x) of psql for more readable output.

    babelfish_db=> \x babelfish_db=> SELECT babelfish_db=> aurora_version() AS aurora_version, babelfish_db=> version() AS postgresql_version, babelfish_db=> sys.version() AS Babelfish_compatibility, babelfish_db=> sys.SERVERPROPERTY('BabelfishVersion') AS Babelfish_Version;

    The query returns output similar to the following:

    -[ RECORD 1 ]-----------+----------------------------------------------------------------------------------------------- aurora_version | 14.3.0 postgresql_version | PostgreSQL 14.3 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit babelfish_compatibility | Babelfish for Aurora Postgres with SQL Server Compatibility - 12.0.2000.8 + | May 23 2022 19:17:14 + | Copyright (c) Amazon Web Services + | PostgreSQL 14.3 on x86_64-pc-linux-gnu babelfish_version | 2.1.0