I'm using Ubuntu 10.04 LTS Server and Postgresql 8.4.8.
I'm trying to set up Cybertec's ODBC_LINK program (http://www.cybertec.at/download/odbc..._odbc_link.pdf
so I can read MS-SQL data into my Postgresql 8.4.8 database.
Their build instructions say to Compile the module using make USE_PGXS=1.
sudo make USE_PGXS=1
sudo make install USE_PGXS=1
When I run that I get:
postgres@dev-postgres-1:~/ODBC-Link-1.0.4$ make USE_PGXS=1
Makefile:12: /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk: No such file or directory
make: *** No rule to make target `/usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk'. Stop.
I had to manually install the libpq-dev library (which informed that it replaces postgresql-dev library) and I manually created a folder for ' /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/" but I don't have a pgxs.mk file to paste into that "makefiles" folder. But apparently that installation did not install the files including /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk
Why are the PGXS files / folders not automatically created for me? How can i install PGXS so that the make process succeeds?
If someone knows an easier way to read directly from a MS-SQL table or view into a Postgres function I'd love to know about it! I don't want to use MSSQL DTS as i don't have control of that server, so i can't use .csv intermediary files or that kind of strategy (i can only access 2 read-only views on their server). I'm trying to
INSERT INTO postgres_table (pg fields...) SELECT * FROM ODBCSOURCE;
I want to read from that ODBC stream directly in Postgresql, like a SELECT on Linked Servers in MSSQL-world or on a linked table in MSACCESS. That would give control over the ODBC interaction to the PG function rather than a non-DB entity.