http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [195]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2917]
PostgreSQL [103]
기타정보 [151]
운영체제 [584]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: PostgreSQL

 회원가입

odbc_fdw test
최길호 [LIST]   2021-11-22 05:27:06, 조회 : 138

https://github.com/CartoDB/odbc_fdw


cd /psql/odbc_fdw-0.5.2.3
# 8.4.20
grep pgxs Makefile
pg_config --pgxs
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk
# 13.4
psql13
pg_config --pgxs
/psql/13.4/lib/postgresql/pgxs/src/makefiles/pgxs.mk
pg_config --configure
'--prefix=/psql/13.4' '--with-pgport=5413'


cd /psql/odbc_fdw-0.5.2.3
# more Makefile [ 설치 위치 확인 ]
make

root#
cd /psql/odbc_fdw-0.5.2.3
make install
==========================================
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/mkinstalldirs '/usr/lib64/pgsql'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 755  odbc_fdw.so '/usr/lib64/pgsql/odbc_fdw.so'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./odbc_fdw--0.5.2.sql '/usr/share/pgsql/contrib'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./odbc_fdw--0.2.0--0.3.0.sql '/usr/share/pgsql/contrib'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./odbc_fdw--0.2.0--0.4.0.sql '/usr/share/pgsql/contrib'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./odbc_fdw--0.3.0--0.4.0.sql '/usr/share/pgsql/contrib'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./odbc_fdw--0.4.0--0.5.0.sql '/usr/share/pgsql/contrib'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./odbc_fdw--0.5.0--0.5.1.sql '/usr/share/pgsql/contrib'
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./odbc_fdw--0.5.1--0.5.2.sql '/usr/share/pgsql/contrib'



CREATE SERVER odbc_server FOREIGN DATA WRAPPER odbc_fdw OPTIONS (dsn 'oracle');
ERROR:  foreign-data wrapper "odbc_fdw" does not exist

cp /psql/odbc_fdw-0.5.2.3/odbc_fdw.control /psql/13.4/share/postgresql/extension/
cp /usr/share/pgsql/contrib/odbc_fdw* /psql/13.4/share/postgresql/extension/
cp /usr/lib64/pgsql/odbc_fdw.so /psql/13.4/lib/postgresql/

CREATE EXTENSION odbc_fdw;
CREATE SERVER odbc_server FOREIGN DATA WRAPPER odbc_fdw OPTIONS (dsn 'oracle');
CREATE FOREIGN TABLE
  odbc_table (
    id integer,
    name varchar(255)
  )
  SERVER odbc_server
  OPTIONS (
    sql_query 'select file#,name from v$dbfile'
  );

CREATE USER MAPPING FOR postgres
  SERVER odbc_server
  OPTIONS (odbc_UID 'user_000', odbc_PWD 'user_000');

select * from odbc_table;
ERROR:  Connecting to driver


3.239.112.140


  LIST

제목 작성자 작성일 조회
Admin  odbc_fdw test    최길호 2021/11/22 138
Admin  ERROR: cross-database references are not implemented / postgres_fdw / psql dblink    최길호 2021/11/15 185
Admin  CREATE EXTENSION postgres_fdw; [ source install ]    최길호 2021/11/15 292
Admin  psql [ 8.4.20 , 8.4.22 ] 여러 Version 운영, upgrade 8.4.20 to 8.4.22 [ 뒤 Version 다르면 그냥 시작 ]    최길호 2021/11/12 116
Admin  source make install [ 8 ~ 14 ]    최길호 2021/11/11 171
Admin  psql odbc make install    최길호 2021/11/09 134
Admin  oracle to psql dblink    최길호 2021/11/09 155
Admin  /usr/bin/initdb -D /var/lib/pgsql/test [ Instance 추가 ]    최길호 2021/11/05 107
Troubleshoot  connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?    최길호 2021/11/04 168
Troubleshoot  ERROR: current transaction is aborted, commands ignored until end of transaction block; [ postgresql-odbc upgrade ]    최길호 2021/11/04 183
Troubleshoot  pg_ctl start $PGDATA/pg_log/ 한글/영어 메세지 [ $PGDATA/postgresql.conf lc_messages ]    최길호 2021/10/29 205
Admin  pg_dumpall pg_upgrade    최길호 2021/10/21 149
Admin  통계정보    최길호 2021/10/21 124
Admin  pg_dump / pg_restore[ psql (8.4.20) to psql (14.0) ]    최길호 2021/10/20 170
Admin  PostgreSQL 14 / pgadmin Install [ lc_collate 'ko_KR.UTF-8' order by 정상 ]    최길호 2021/10/17 235
Admin  psql dblink to oracle [ odbc test ] 한글    최길호 2021/04/19 2499
Admin  postgres , enterprisedb(EDB) / [ ERROR: type "number" does not exist ]    최길호 2020/09/01 272
Admin  install postgresql on docker centos:7    최길호 2020/08/31 382
Troubleshoot  psql: server closed the connection unexpectedly [ vi $PGDATA/postgresql.conf / listen_addresses='*' ]    최길호 2020/08/31 413

    목록보기   다음페이지 1 [2][3][4][5][6]
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
11/23
[ORACLE]
acfsutil size: ACFS-03006: sma....
by 최길호
11/07
[운영체제]
Job for sshd.service failed be....
by 최길호
11/04
[ORACLE]
jsp error 위치 확인 [ debug ].
by 최길호