Foreign data wrappers for MSSQL 05.07.23

TDS Foreign data wrapper

Author: Geoff Montee
    Name: tds_fdw
    File: tds_fdw/InstallDebian.md

Installing on Debian

This document will show how to install tds_fdw on Debian 10. Other Debian distributions should be similar.
Install FreeTDS and build dependencies

The TDS foreign data wrapper requires a library that implements the DB-Library interface, such as FreeTDS.

sudo apt-get update
sudo apt-get install libsybdb5 freetds-dev freetds-common

Some other dependencies are also needed to install PostgreSQL and then compile tds_fdw:

sudo apt-get install gnupg gcc make

Install PostgreSQL

If you need to install PostgreSQL, do so by following the apt installation directions. For example, to install PostgreSQL 11 on Debian:

sudo bash -c 'source /etc/os-release; echo "deb http://apt.postgresql.org/pub/repos/apt/ ${VERSION_CODENAME}-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
sudo apt-key adv --keyserver hkp://pool.sks-keyservers.net --recv-keys 0xACCC4CF8
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install postgresql-11 postgresql-client-11 postgresql-server-dev-11

NOTE: If you already have PostgreSQL installed on your system be sure that the package postgresql-server-dev-XX is installed too (where XX stands for your PostgreSQL version).
Install tds_fdw
Build from release package

If you'd like to use one of the release packages, you can download and install them via something like the following:

export TDS_FDW_VERSION="2.0.3"
sudo apt-get install wget
wget https://github.com/tds-fdw/tds_fdw/archive/v${TDS_FDW_VERSION}.tar.gz
tar -xvzf v${TDS_FDW_VERSION}.tar.gz
cd tds_fdw-${TDS_FDW_VERSION}/
make USE_PGXS=1
sudo make USE_PGXS=1 install

NOTE: If you have several PostgreSQL versions and you do not want to build for the default one, first locate where the binary for pg_config is, take note of the full path, and then append PG_CONFIG=<PATH> after USE_PGXS=1 at the make commands.
Build from repository

If you would rather use the current development version, you can clone and build the git repository via something like the following:

sudo apt-get install git
git clone https://github.com/tds-fdw/tds_fdw.git
cd tds_fdw
make USE_PGXS=1
sudo make USE_PGXS=1 install

If this is a fresh installation, then start the server:

sudo service postgresql start

Install extension

psql -U postgres
postgres=# CREATE EXTENSION tds_fdw;

https://github.com/tds-fdw/tds_fdw/blob/master/InstallDebian.md

Anonymous

The binary is installed here

make USE_PGXS=1 install
```
/bin/mkdir -p '/usr/lib/postgresql/17/lib'
/bin/mkdir -p '/usr/share/postgresql/17/extension'
/bin/mkdir -p '/usr/share/postgresql/17/extension'
/bin/mkdir -p '/usr/share/doc/postgresql-doc-17/extension'
/usr/bin/install -c -m 755  tds_fdw.so '/usr/lib/postgresql/17/lib/tds_fdw.so'
/usr/bin/install -c -m 644 .//tds_fdw.control '/usr/share/postgresql/17/extension/'
/usr/bin/install -c -m 644 .//tds_fdw--2.0.1--2.0.2.sql .//tds_fdw--2.0.2--2.0.3.sql .//tds_fdw--2.0.3--2.0.4.sql .//sql/tds_fdw--2.0.4.sql  '/usr/share/postgresql/17/extension/'
/usr/bin/install -c -m 644 .//README.tds_fdw.md '/usr/share/doc/postgresql-doc-17/extension/'
/bin/mkdir -p '/usr/lib/postgresql/17/lib/bitcode/tds_fdw'
/bin/mkdir -p '/usr/lib/postgresql/17/lib/bitcode'/tds_fdw/src/
/usr/bin/install -c -m 644 src/tds_fdw.bc '/usr/lib/postgresql/17/lib/bitcode'/tds_fdw/src/
/usr/bin/install -c -m 644 src/options.bc '/usr/lib/postgresql/17/lib/bitcode'/tds_fdw/src/
/usr/bin/install -c -m 644 src/deparse.bc '/usr/lib/postgresql/17/lib/bitcode'/tds_fdw/src/
cd '/usr/lib/postgresql/17/lib/bitcode' && /usr/lib/llvm-16/bin/llvm-lto -thinlto -thinlto-action=thinlink -o tds_fdw.index.bc tds_fdw/src/tds_fdw.bc tds_fdw/src/options.bc tds_fdw/src/deparse.bc
```

05.07.23

Anonymous

Foreign data wrappers for MSSQL 05.07.23

Information Epoch 1737543831