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]
°³ÀÎÆú´õ [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [41]
DB2 [79]
ORACLE [2942]
PSQL [132]
±âŸÁ¤º¸ [151]
¿î¿µÃ¼Á¦ [588]
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, Á¶È¸ : 235

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.236.209.138


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Admin  HA º¹±¸ test    ÃÖ±æÈ£ 2023/03/03 5
Admin  log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump ¹é¾÷½Ã ¹ß»ý    ÃÖ±æÈ£ 2023/03/03 4
Admin  requested timeline x is not a child of this server's history    ÃÖ±æÈ£ 2023/03/02 5
Admin  recovery_target_action / archive log ¹Þ¾Æ¼­ °è¼Ó º¹±¸    ÃÖ±æÈ£ 2023/02/28 7
Admin  recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();    ÃÖ±æÈ£ 2023/02/27 4
Admin  memory buffer cache    ÃÖ±æÈ£ 2023/02/06 5
Admin  active session, pid, lock sql , kill pid / pg_terminate_backend    ÃÖ±æÈ£ 2023/02/06 13
Admin  psql HA    ÃÖ±æÈ£ 2023/02/05 13
Admin  pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |    ÃÖ±æÈ£ 2023/02/03 4
Admin  pg_waldump    ÃÖ±æÈ£ 2023/02/03 4
Troubleshoot  $PGDATA/pg_wal/00000002.history ¾ø´Â°æ¿ì [ ERROR: could not open file "pg_wal/00000002.history": ENOENT ]    ÃÖ±æÈ£ 2023/02/02 4
Admin  pg_basebackup º¹±¸ test lv:9   ÃÖ±æÈ£ 2023/02/02 14
Admin  shmem_exit(0): 0 before_shmem_exit callbacks to make [ ·Î±× ±â·Ï¿ë ]    ÃÖ±æÈ£ 2023/02/01 2
Troubleshoot  LOG: invalid resource manager ID in primary checkpoint record    ÃÖ±æÈ£ 2023/02/01 7
Admin  pg_restore [ ´Ù¸¥ °èÁ¤, ´Ù¸¥ DB, sql ÆÄÀÏ·Î ÀúÀå ]    ÃÖ±æÈ£ 2023/01/30 3
Admin  pg_basebackup pg_dump pg_dumpall backup script    ÃÖ±æÈ£ 2023/01/30 16
Admin  session Á¤º¸    ÃÖ±æÈ£ 2023/01/27 11
Admin  limit fetch offset rows    ÃÖ±æÈ£ 2023/01/21 7
Admin  pg_resetwal -D $PGDATA --wal-segsize 2 [ wal size º¯°æ ]    ÃÖ±æÈ£ 2023/01/20 8

    ¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö 1 [2][3][4][5][6][7]
       

Copyright 1999-2023 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
ÃÖ±Ù °Ô½Ã¹°
03/28
[¿î¿µÃ¼Á¦]
listView.getChildAt(i).setEnab....
by ÃÖ±æÈ£
03/14
[ORACLE]
Java (1.7) could not be locate....
by ÃÖ±æÈ£
03/10
[ORACLE]
EXP-00111: Table CREATE$JAVA$L....
by ÃÖ±æÈ£