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

 회원가입

psql odbc make install
최길호 [LIST]   2021-11-09 23:14:38, 조회 : 134

https://www.postgresql.org/ftp/odbc/versions/src/

psqlodbc-07.03.0100.tar.gz psqlodbc-07.03.0100.tar.gz        2003-05-15 15:56:27        435.6 KB
psqlodbc-07.03.0200.tar.gz psqlodbc-07.03.0200.tar.gz        2003-10-22 13:46:53        440.7 KB
psqlodbc-08.00.0100.tar.gz psqlodbc-08.00.0100.tar.gz        2005-03-02 14:35:07        572.5 KB
psqlodbc-08.00.0101.tar.gz psqlodbc-08.00.0101.tar.gz        2005-03-05 11:56:13        573.2 KB
psqlodbc-08.00.0102.tar.gz psqlodbc-08.00.0102.tar.gz        2005-08-02 08:03:36        540.0 KB
psqlodbc-08.01.0100.tar.gz psqlodbc-08.01.0100.tar.gz        2005-11-05 21:16:39        574.0 KB
psqlodbc-08.01.0101.tar.gz psqlodbc-08.01.0101.tar.gz        2005-11-11 08:32:46        574.1 KB
psqlodbc-08.01.0102.tar.gz psqlodbc-08.01.0102.tar.gz        2005-12-01 09:22:40        574.6 KB
psqlodbc-08.01.0200.tar.gz psqlodbc-08.01.0200.tar.gz        2006-02-02 09:18:45        582.2 KB
psqlodbc-08.02.0100.tar.gz psqlodbc-08.02.0100.tar.gz        2006-08-31 09:18:09        604.2 KB
psqlodbc-08.02.0200.tar.gz psqlodbc-08.02.0200.tar.gz        2006-10-24 15:03:59        672.5 KB
psqlodbc-08.02.0300.tar.gz psqlodbc-08.02.0300.tar.gz        2007-04-21 11:04:46        723.4 KB
psqlodbc-08.02.0400.tar.gz psqlodbc-08.02.0400.tar.gz        2007-04-27 08:09:39        720.3 KB
psqlodbc-08.02.0500.tar.gz psqlodbc-08.02.0500.tar.gz        2007-09-25 09:32:42        723.3 KB
psqlodbc-08.03.0100.tar.gz psqlodbc-08.03.0100.tar.gz        2008-01-22 12:17:34        738.2 KB
psqlodbc-08.03.0200.tar.gz psqlodbc-08.03.0200.tar.gz        2008-05-04 16:48:14        740.1 KB
psqlodbc-08.03.0300.tar.gz psqlodbc-08.03.0300.tar.gz        2008-09-26 13:59:15        713.0 KB
psqlodbc-08.03.0400.tar.gz psqlodbc-08.03.0400.tar.gz        2008-11-07 14:42:25        713.6 KB
psqlodbc-08.04.0100.tar.gz psqlodbc-08.04.0100.tar.gz        2009-07-21 13:50:00        719.4 KB
psqlodbc-08.04.0200.tar.gz psqlodbc-08.04.0200.tar.gz        2009-12-26 15:44:31        708.4 KB
psqlodbc-09.00.0100.tar.gz psqlodbc-09.00.0100.tar.gz        2010-10-07 16:26:10        744.3 KB
psqlodbc-09.00.0101.tar.gz psqlodbc-09.00.0101.tar.gz        2010-10-16 15:28:54        749.4 KB
psqlodbc-09.00.0200.tar.gz psqlodbc-09.00.0200.tar.gz        2010-10-30 16:18:54        750.5 KB
psqlodbc-09.00.0300.tar.gz psqlodbc-09.00.0300.tar.gz        2011-05-09 12:56:07        724.7 KB
psqlodbc-09.00.0310.tar.gz psqlodbc-09.00.0310.tar.gz        2011-07-08 15:15:36        752.9 KB
psqlodbc-09.01.0100.tar.gz psqlodbc-09.01.0100.tar.gz        2011-12-30 15:17:38        758.1 KB
psqlodbc-09.01.0200.tar.gz psqlodbc-09.01.0200.tar.gz        2012-08-20 03:50:56        732.1 KB
psqlodbc-09.02.0100.tar.gz psqlodbc-09.02.0100.tar.gz        2013-06-03 14:37:12        720.9 KB
psqlodbc-09.03.0100.tar.gz psqlodbc-09.03.0100.tar.gz        2013-12-18 16:06:58        750.9 KB
psqlodbc-09.03.0200.tar.gz psqlodbc-09.03.0200.tar.gz        2014-02-23 06:44:32        764.1 KB
psqlodbc-09.03.0210.tar.gz psqlodbc-09.03.0210.tar.gz        2014-03-08 12:05:38        766.2 KB
psqlodbc-09.03.0300.tar.gz psqlodbc-09.03.0300.tar.gz        2014-05-17 13:25:01        771.8 KB
psqlodbc-09.03.0400.tar.gz psqlodbc-09.03.0400.tar.gz        2014-10-26 12:11:05        802.0 KB
psqlodbc-09.05.0100.tar.gz psqlodbc-09.05.0100.tar.gz        2016-01-10 14:29:34        780.1 KB
psqlodbc-09.05.0200.tar.gz psqlodbc-09.05.0200.tar.gz        2016-04-09 14:25:02        782.6 KB
psqlodbc-09.05.0210.tar.gz psqlodbc-09.05.0210.tar.gz        2016-04-15 14:25:55        789.6 KB
psqlodbc-09.05.0300.tar.gz psqlodbc-09.05.0300.tar.gz        2016-06-17 15:11:37        791.2 KB
psqlodbc-09.05.0400.tar.gz psqlodbc-09.05.0400.tar.gz        2016-07-30 15:30:34        793.6 KB
psqlodbc-09.06.0100.tar.gz psqlodbc-09.06.0100.tar.gz        2017-02-03 13:52:29        865.3 KB
psqlodbc-09.06.0200.tar.gz psqlodbc-09.06.0200.tar.gz        2017-03-10 15:40:53        867.0 KB
psqlodbc-09.06.0300.tar.gz psqlodbc-09.06.0300.tar.gz        2017-05-07 14:34:05        877.0 KB
psqlodbc-09.06.0310.tar.gz psqlodbc-09.06.0310.tar.gz        2017-05-11 15:19:13        877.1 KB
psqlodbc-09.06.0400.tar.gz psqlodbc-09.06.0400.tar.gz        2017-07-18 14:35:47        883.4 KB
psqlodbc-09.06.0410.tar.gz psqlodbc-09.06.0410.tar.gz        2017-07-27 14:13:00        886.1 KB
psqlodbc-09.06.0500.tar.gz psqlodbc-09.06.0500.tar.gz        2017-09-05 14:30:09        890.4 KB
psqlodbc-10.00.0000.tar.gz psqlodbc-10.00.0000.tar.gz        2017-10-13 14:23:53        892.7 KB
psqlodbc-10.01.0000.tar.gz psqlodbc-10.01.0000.tar.gz        2017-12-27 14:39:54        893.7 KB
psqlodbc-10.02.0000.tar.gz psqlodbc-10.02.0000.tar.gz        2018-03-30 14:31:45        893.3 KB
psqlodbc-10.03.0000.tar.gz psqlodbc-10.03.0000.tar.gz        2018-05-19 13:14:45        894.5 KB
psqlodbc-11.00.0000.tar.gz psqlodbc-11.00.0000.tar.gz        2018-11-17 13:50:44        896.9 KB
psqlodbc-11.01.0000.tar.gz psqlodbc-11.01.0000.tar.gz        2019-05-24 14:28:41        897.8 KB
psqlodbc-12.00.0000.tar.gz psqlodbc-12.00.0000.tar.gz        2019-10-11 14:14:31        899.1 KB
psqlodbc-12.01.0000.tar.gz psqlodbc-12.01.0000.tar.gz        2020-01-07 13:53:45        910.8 KB
psqlodbc-12.02.0000.tar.gz psqlodbc-12.02.0000.tar.gz        2020-05-26 13:01:09        915.9 KB
psqlodbc-13.00.0000.tar.gz psqlodbc-13.00.0000.tar.gz        2020-11-19 09:53:51        918.0 KB
psqlodbc-13.01.0000.tar.gz psqlodbc-13.01.0000.tar.gz        2021-05-02 12:27:32        919.0 KB
psqlodbc-13.02.0000.tar.gz psqlodbc-13.02.0000.tar.gz        2021-09-22 10:45:31        922.2 KB
psqlodbc-7.2.3.tar.gz psqlodbc-7.2.3.tar.gz        2002-10-16 09:09:45        358.6 KB
psqlodbc-7.2.4.tar.gz psqlodbc-7.2.4.tar.gz        2002-11-12 08:41:45        396.9 KB
psqlodbc-7.2.5.tar.gz psqlodbc-7.2.5.tar.gz        2002-11-29 16:10:34        406.1 KB


출처 : https://printstack.hatenablog.jp/entry/2010/03/24/161000
오류 수정

cd /usr/local/src
tar xzvf psqlodbc-08.04.0200.tar.gz
chown -R postgres.postgres psqlodbc-08.04.0200

cd /usr/local/src/psqlodbc-08.04.0200
export LDFLAGS='-Xlinker -rpath /usr/pgsql-9.6/lib'
ln -s /usr/pgsql-9.6/lib/psqlodbcw.so psqlodbcw.so
./configure --with-unixodbc --with-libpq=/var/lib/pgsql
chown -R postgres.postgres . *

su - postgres
vi .bash_profile
export LD_LIBRARY_PATH=/usr/local/lib:/usr/lib64:/lib64:/usr/pgsql-9.6/lib

cd /usr/local/src/psqlodbc-08.04.0200
make

에러 메세지
/usr/bin/ld: psqlodbcw.so: No such file: No such file or directory
collect2: ld returned 1 exit status
make[1]: *** [psqlodbcw.la] Error 1
make[1]: Leaving directory `/usr/local/src/psqlodbc-08.04.0200'
make: *** [all] Error 2
조치: ln -s /usr/pgsql-9.6/lib/psqlodbcw.so psqlodbcw.so

root#
cd /usr/local/src/psqlodbc-08.04.0200
make install
ls -al /usr/local/lib/psqlodbcw.so
-rwxr-xr-x. 1 root root 1591092 Nov  9 22:56 /usr/local/lib/psqlodbcw.so

vi /etc/odbc.ini
[psql]
#Driver=PostgreSQL
Driver=/usr/local/lib/psqlodbcw.so
# [01000][unixODBC][Driver Manager]Can't open lib '/usr/local/lib/psqlodbcw.so' : file not found
# export LD_LIBRARY_PATH=/usr/local/lib
# ldd /usr/local/lib/psqlodbcw.so

isql -v psql
SQL> select * from test;
+-----------+
| 한글      |
+-----------+
| Hi~ 안녕  |
+-----------+
3.239.112.140


  LIST

제목 작성자 작성일 조회
Admin  odbc_fdw test    최길호 2021/11/22 139
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 최길호