search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
357 stars 99 forks source link

could not open extension control file "/usr/share/postgresql/13/extension/tds_fdw.control": No such file or directory #296

Open bamper197801 opened 2 years ago

bamper197801 commented 2 years ago

the tds_fdw.control file is installed in the / usr / share / postgresql / 14 / extension # directory, and when installing via CREATE EXTENSION tds_fdw; looking for it in / usr / share / postgresql / 13 / extension, how can I install the extension to the desired directory?

GeoffMontee commented 2 years ago

The control file is installed to the $libdir for the PostgreSQL installation:

module_pathname = '$libdir/tds_fdw'

https://github.com/tds-fdw/tds_fdw/blob/master/tds_fdw.control#L20

If your control file is being installed to the $libdir for PostgreSQL 13 instead of 14, then you may have accidentally built tds_fdw using the wrong pg_config executable. You can specify a different pg_config executable at build time like this:

make USE_PGXS=1 PG_CONFIG=/usr/pgsql-11/bin/pg_config
sudo make USE_PGXS=1 PG_CONFIG=/usr/pgsql-11/bin/pg_config install

https://github.com/tds-fdw/tds_fdw/blob/master/InstallCentOS.md#build-from-release-package