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

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [95]
Site Link [17]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [25]
MySQL [43]
DB2 [79]
ORACLE [3003]
PSQL [134]
기타정보 [155]
운영체제 [603]
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, 조회 : 187

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


  LIST

제목 작성자 작성일 조회
Admin  psql 10.7 oracle dblink [ oracle_fdw db link ]    최길호 2023/07/25 20
Admin  HA 복구 test    최길호 2023/03/03 31
Admin  log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump 백업시 발생    최길호 2023/03/03 14
Admin  requested timeline x is not a child of this server's history    최길호 2023/03/02 16
Admin  recovery_target_action / archive log 받아서 계속 복구    최길호 2023/02/28 25
Admin  recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();    최길호 2023/02/27 6
Admin  memory buffer cache    최길호 2023/02/06 14
Admin  active session, pid, lock sql , kill pid / pg_terminate_backend    최길호 2023/02/06 60
Admin  psql HA    최길호 2023/02/05 46
Admin  pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |    최길호 2023/02/03 31
Admin  pg_waldump    최길호 2023/02/03 9
Troubleshoot  $PGDATA/pg_wal/00000002.history 없는경우 [ ERROR: could not open file "pg_wal/00000002.history": ENOENT ]    최길호 2023/02/02 24
Admin  pg_basebackup 복구 test lv:9   최길호 2023/02/02 23
Admin  shmem_exit(0): 0 before_shmem_exit callbacks to make [ 로그 기록용 ]    최길호 2023/02/01 46
Troubleshoot  LOG: invalid resource manager ID in primary checkpoint record    최길호 2023/02/01 24
Admin  pg_restore [ 다른 계정, 다른 DB, sql 파일로 저장 ]    최길호 2023/01/30 16
Admin  pg_basebackup pg_dump pg_dumpall backup script    최길호 2023/01/30 79
Admin  session 정보    최길호 2023/01/27 21

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

Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
12/01
[ORACLE]
dgmgrl 운영, db11st h/w 교체 시나리....
by 최길호
12/01
[ORACLE]
DGMGRL> show configuration;....
by 최길호
11/23
[운영체제]
arch filesystem 100% full 예방 /....
by 최길호