[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [72]
02.File Book
File 자료실 [96]
Site Link [14]
개인폴더 [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [28]
MySQL [47]
DB2 [79]
ORACLE [3072]
PSQL [135]
CUBRID [5]
기타정보 [170]
운영체제 [611]
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, 조회 : 218

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


100.28.2.72


  LIST

제목 작성자 작성일 조회
Admin  pg_backup_start / pg_backup_stop / psql 세션 유지 / WARNING: aborting backup due to backend exiting before pg_backup_stop was called    최길호 2023/12/21 45
Admin  psql 10.7 oracle dblink [ oracle_fdw db link ]    최길호 2023/07/25 46
Admin  HA 복구 test    최길호 2023/03/03 90
Admin  log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump 백업시 발생    최길호 2023/03/03 37
Admin  requested timeline x is not a child of this server's history    최길호 2023/03/02 35
Admin  recovery_target_action / archive log 받아서 계속 복구    최길호 2023/02/28 49
Admin  recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();    최길호 2023/02/27 25
Admin  memory buffer cache    최길호 2023/02/06 31
Admin  active session, pid, lock sql , kill pid / pg_terminate_backend    최길호 2023/02/06 94
Admin  psql HA    최길호 2023/02/05 83
Admin  pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |    최길호 2023/02/03 51
Admin  pg_waldump    최길호 2023/02/03 33
Troubleshoot  $PGDATA/pg_wal/00000002.history 없는경우 [ ERROR: could not open file "pg_wal/00000002.history": ENOENT ]    최길호 2023/02/02 48
Admin  shmem_exit(0): 0 before_shmem_exit callbacks to make [ 로그 기록용 ]    최길호 2023/02/01 76
Troubleshoot  LOG: invalid resource manager ID in primary checkpoint record    최길호 2023/02/01 45
Admin  pg_restore [ 다른 계정, 다른 DB, sql 파일로 저장 ]    최길호 2023/01/30 40
Admin  pg_basebackup pg_dump pg_dumpall backup script    최길호 2023/01/30 146
Admin  session 정보    최길호 2023/01/27 44

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

Copyright 1999-2024 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
06/20
[ORACLE]
OGG-15161.
by 최길호
06/15
[ORACLE]
RMAN-06053: unable to perform ....
by 최길호
06/05
[운영체제]
localectl set-locale LANG=en_U....
by 최길호