Sign inSign up

muritiku/postgres-tds

By muritiku

•Updated over 7 years ago

Docker image of PostgreSQL with additions (languages, extensions, etc...)

Image
0

1.5K

muritiku/postgres-tds repository overview

⁠PostgreSQL-11

⁠With oracle_fdw & tds_fdw (sybase & ms-sql) & pl/python 3 (plpython3u language)

by Anton Dziavitsyn 2019
[email protected]⁠

Repository on GitHub: https://github.com/Muritiku/postgres-tds⁠

⁠Image on DockerHub

Builded docker image: muritiku/postgres-tds⁠

⁠How to run

You can use docker-compose.yml to build postgres+adminier for tests:

docker-compose -f pgsql-adminer.yml up

Then connect to postgreSQL instance, with using user: postgres, password: 1234
You may change credentials with using environment variables (POSTGRES_USER and POSTGRES_PASSWORD) in compose file.

⁠Using tds_fdw for MS-SQL schema access (mapping)

Original documentation⁠

Activate extension:

CREATE EXTENSION tds_fdw;

Connect server:

CREATE SERVER mssql_svr
	FOREIGN DATA WRAPPER tds_fdw
	OPTIONS (servername '127.0.0.1', port '1433', database 'tds_fdw_test', tds_version '7.1');

Grant user access:

GRANT USAGE ON FOREIGN SERVER mssql_svr TO postgres_username;

Create user mapping:

CREATE USER MAPPING FOR postgres_username
	SERVER mssql_svr 
	OPTIONS (username 'sa', password '');

Import MS-SQL schema:

IMPORT FOREIGN SCHEMA dbo
	FROM SERVER mssql_svr
	INTO public
	OPTIONS (import_default 'true');

⁠Using oracle_fdw for Oracle schema access (mapping)

Original documentation⁠

Activate extension:

CREATE EXTENSION oracle_fdw;

Connect server:

CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw
          OPTIONS (dbserver '//dbserver.mydomain.com:1521/ORADB');

Grant user access:

GRANT USAGE ON FOREIGN SERVER oradb TO postgres_username;

Create user mapping:

CREATE USER MAPPING FOR postgres_username
          SERVER oradb
          OPTIONS (user 'orauser', password 'orapwd');

Import ORACLE schema:

IMPORT FOREIGN SCHEMA ORA_SCHEMA
	FROM SERVER oradb
	INTO public;

Tag summary

Content type

Image

Digest

Size

431.8 MB

Last updated

over 7 years ago

docker pull muritiku/postgres-tds