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]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
기타정보 [150]
운영체제 [577]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

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

 회원가입

ERROR: current transaction is aborted, commands ignored until end of transaction block; [ postgresql-odbc upgrade ]
최길호 [LIST]   2021-11-04 11:00:48, 조회 : 108

SQL> select * from "test"@psql;
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ERROR:  current transaction is aborted, commands ignored until end of transaction block;
No query has been executed with that handle {HY000,NativeErr = 1}
ORA-02063: preceding 3 lines from PSQL

ODBC Version postgresql-odbc-08.04 문제
출처: https://kb.tableau.com/articles/issue/Error-error-Current-Transaction-Is-Aborted-Commands-Ignored-Until-End-Of-Transaction-Block-Error-While-Executing-The-Query-when-connecting-or-interacting-with-Postgresql-Data-Source?lang=ko-kr

yum erase postgresql-odbc
====================================================================================================================================
Package                           Arch                     Version                             Repository                     Size
====================================================================================================================================
Removing:
postgresql-odbc                   x86_64                   08.04.0200-1.el6                    @C6.10-base                   668 k

조치 download
https://www.postgresql.org/download/linux/redhat/ [ script 제공 ]
yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-6-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install postgresql96-odbc


====================================================================================================================================
Package                            Arch                    Version                                   Repository               Size
====================================================================================================================================
Installing:
postgresql96-odbc                  x86_64                  12.01.0000-1PGDG.rhel6                    pgdg96                  311 k
Installing for dependencies:
postgresql96-libs                  x86_64                  9.6.23-1PGDG.rhel6                        pgdg96                  294 k
Transaction Summary
====================================================================================================================================
Install       2 Package(s)
Total download size: 605 k
Installed size: 2.0 M
Is this ok [y/N]: yes
Downloading Packages:
(1/2): postgresql96-libs-9.6.23-1PGDG.rhel6.x86_64.rpm                                                       | 294 kB     00:00    
(2/2): postgresql96-odbc-12.01.0000-1PGDG.rhel6.x86_64.rpm                                                   | 311 kB     00:00    

psqlodbc.so 위치 확인
rpm -ql postgresql96-odbc
---------------------------------------------------------
/usr/pgsql-9.6/lib/psqlodbc.so
/usr/pgsql-9.6/lib/psqlodbca.so
/usr/pgsql-9.6/lib/psqlodbcw.so
/usr/share/doc/postgresql96-odbc-12.01.0000
/usr/share/doc/postgresql96-odbc-12.01.0000/license.txt
/usr/share/doc/postgresql96-odbc-12.01.0000/readme.txt


cat /etc/odbcinst.ini
[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/pgsql-9.6/lib/psqlodbc.so
Driver64        = /usr/pgsql-9.6/lib/psqlodbc.so
FileUsage       = 1


cat $ORACLE_HOME/hs/admin/initpsql.ora
HS_FDS_CONNECT_INFO = psql
HS_FDS_TRACE_LEVEL = 0
HS_FDS_TRACE_FILE_NAME=/oracle/product/18/hs/admin/psql.log
HS_FDS_SHAREABLE_NAME =/usr/pgsql-9.6/lib/psqlodbc.so
set ODBCINI=/etc/odbc.ini

3.235.78.122


  LIST

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

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

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by 최길호
06/25
[ORACLE]
Replication may not be valid i....
by 최길호
06/22
[운영체제]
CentOS7 홈페이지 Migration 메모.
by 최길호