If you have an existing installation of TDS foreign data wrapper that you installed using the EDB repository, you can update your repository configuration file and then upgrade TDS foreign data wrapper to a more recent product version.
To perform the process, open a terminal window and enter the commands that apply to the operating system and package manager used for the installation.
To update your repository configuration file:
sudo <package-manager> upgrade edb-repo
Where <package-manager> is the package manager used with your operating system:
| Package manager | Operating system |
|---|---|
| dnf | RHEL 8/9 and derivatives |
| apt-get | Debian and Ubuntu |
To upgrade to the latest product version, enter one of the following commands:
| Operating system | Upgrade command |
|---|---|
| RHEL 8/9 and derivatives | sudo dnf upgrade edb-as<xx>-tds-fdw |
| Debian and Ubuntu | sudo apt-get --only-upgrade install edb-as<xx>-tds-fdw |
Where:
<package-manager>is the package manager used with your operating system.<xx>is the EDB Postgres Advanced Server version number.
After upgrading the package, update the extension in each database where it's installed. Connect to your Postgres server and enter:
ALTER EXTENSION tds_fdw UPDATE;
To update to a specific version, enter:
ALTER EXTENSION tds_fdw UPDATE TO '<version>';
Where <version> is the version to update to, for example, 2.0.5.