database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
ㆍPostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
PostgreSQL Q&A 4880 게시물 읽기
No. 4880
레드햇 9.0 설치 후 postgresql 구버젼 설치시 문제
작성자
강승진(sjlover)
작성일
2003-08-13 10:41
조회수
3,154

한컴 2.0을 사용하다 하드디스크를 추가하면서 레드햇 9.0을 깔았습니다..

 

물론 postgresql 데이타베이스는 덤프를 떠 놓았지요..

 

레드햇 9.0은 postgresql 7.3 이 이미 설치되어 있는데,

 

서버에서 돌리는 상용프로그램에서 아직 postgresql 7.3을 지원하지 않습니다

 

(준비중이라고는 하는데.. ㅡ,ㅡㅋ 시간이 좀 걸립니다..)

 

그러한 연고로

 

postgresql 7.2(레드햇 8.0용) rpm을 받아다가 삽질 중입니다..

 

1. postgresql 7.3.2-3 rpm 삭제

 

rpm -e postgresql-server

rpm -e postgresql

rpm -e perl - DBD -Pg (의존성 때문에 삭제)

rpm -e postgesql-libs

 

그 외에 것들도..postgresql 이란 말 들어간 것은

싹 날려 주었습니다~ (먼지 기억 안남..ㅡ ㅁ ㅡ ;)

 

2. postgresql 7.2 rpm 설치

 

 

rpm -ivh postgresql-libs-7.2.3-5.80.i386.rpm

오류: Failed dependencies:

libcrypto.so.2 is needed by postgresql-libs-7.2.3-5.80

libssl.so.2 is needed by postgresql-libs-7.2.3-5.80

 

rpm -ivh postgresql-7.2.3-5.80.i386.rpm

오류: Failed dependencies:

libcrypto.so.2 is needed by postgresql-7.2.3-5.80

libpq.so.2 is needed by postgresql-7.2.3-5.80

libssl.so.2 is needed by postgresql-7.2.3-5.80

 

=> libcrypto.so.2 와 libssl.so.2는 openssl-0.9.6b-33.i386.rpm을 설치하면 문제해결이더군여... 그래서 먼저 설치된 openssl을 삭제하려 해 보았습니다.. 그랬더니 .. 의존성에서 난리가 났습니다..ㅜ _ ㅜ

 

rpm -e openssl

오류: Failed dependencies:

libcrypto.so.4 is needed by (installed) python-2.2.2-26

libcrypto.so.4 is needed by (installed) cyrus-sasl-2.1.10-4

libcrypto.so.4 is needed by (installed) cyrus-sasl-md5-2.1.10-4

libcrypto.so.4 is needed by (installed) openldap-2.0.27-8

libcrypto.so.4 is needed by (installed) bind-utils-9.2.1-16

libcrypto.so.4 is needed by (installed) lftp-2.6.3-3

libcrypto.so.4 is needed by (installed) libwvstreams-3.70-8

libcrypto.so.4 is needed by (installed) openssh-3.5p1-6

libcrypto.so.4 is needed by (installed) openssh-clients-3.5p1-6

libcrypto.so.4 is needed by (installed) pyOpenSSL-0.5.1-8

libcrypto.so.4 is needed by (installed) openssh-server-3.5p1-6

libcrypto.so.4 is needed by (installed) sendmail-8.12.8-4

libcrypto.so.4 is needed by (installed) stunnel-4.04-3

libcrypto.so.4 is needed by (installed) wget-1.8.2-9

libcrypto.so.4 is needed by (installed) curl-7.9.8-5

libcrypto.so.4 is needed by (installed) httpd-2.0.40-21

libcrypto.so.4 is needed by (installed) mod_ssl-2.0.40-21

libcrypto.so.4 is needed by (installed) php-4.2.2-17

libcrypto.so.4 is needed by (installed) php-imap-4.2.2-17

libcrypto.so.4 is needed by (installed) squid-2.5.STABLE1-2

libcrypto.so.4 is needed by (installed) cups-libs-1.1.17-13

libcrypto.so.4 is needed by (installed) samba-common-2.2.7a-7.9.0

libcrypto.so.4 is needed by (installed) samba-2.2.7a-7.9.0

libcrypto.so.4 is needed by (installed) samba-client-2.2.7a-7.9.0

libcrypto.so.4 is needed by (installed) cups-1.1.17-13

libcrypto.so.4 is needed by (installed) bind-9.2.1-16

libcrypto.so.4 is needed by (installed) gnome-vfs2-2.2.2-4

libcrypto.so.4 is needed by (installed) gnome-vfs-1.0.5-13

libcrypto.so.4 is needed by (installed) gnome-pilot-0.1.71-2

libcrypto.so.4 is needed by (installed) soup-0.7.10-4

libcrypto.so.4 is needed by (installed) xchat-1.8.11-7

libcrypto.so.4 is needed by (installed) libgnomeprint22-2.2.1.1-3

libcrypto.so.4 is needed by (installed) evolution-1.2.2-4

libcrypto.so.4 is needed by (installed) cyrus-sasl-devel-2.1.10-4

libcrypto.so.4 is needed by (installed) imap-2001a-18

libcrypto.so.4 is needed by (installed) net-snmp-5.0.6-17

libcrypto.so.4 is needed by (installed) ethereal-0.9.8-6

libssl.so.4 is needed by (installed) python-2.2.2-26

libssl.so.4 is needed by (installed) openldap-2.0.27-8

libssl.so.4 is needed by (installed) lftp-2.6.3-3

libssl.so.4 is needed by (installed) libwvstreams-3.70-8

libssl.so.4 is needed by (installed) pyOpenSSL-0.5.1-8

libssl.so.4 is needed by (installed) sendmail-8.12.8-4

libssl.so.4 is needed by (installed) stunnel-4.04-3

libssl.so.4 is needed by (installed) wget-1.8.2-9

libssl.so.4 is needed by (installed) curl-7.9.8-5

libssl.so.4 is needed by (installed) httpd-2.0.40-21

libssl.so.4 is needed by (installed) mod_ssl-2.0.40-21

libssl.so.4 is needed by (installed) php-4.2.2-17

libssl.so.4 is needed by (installed) php-imap-4.2.2-17

libssl.so.4 is needed by (installed) squid-2.5.STABLE1-2

libssl.so.4 is needed by (installed) cups-libs-1.1.17-13

libssl.so.4 is needed by (installed) samba-common-2.2.7a-7.9.0

libssl.so.4 is needed by (installed) samba-2.2.7a-7.9.0

libssl.so.4 is needed by (installed) samba-client-2.2.7a-7.9.0

libssl.so.4 is needed by (installed) cups-1.1.17-13

libssl.so.4 is needed by (installed) gnome-vfs2-2.2.2-4

libssl.so.4 is needed by (installed) gnome-vfs-1.0.5-13

libssl.so.4 is needed by (installed) soup-0.7.10-4

libssl.so.4 is needed by (installed) xchat-1.8.11-7

libssl.so.4 is needed by (installed) libgnomeprint22-2.2.1.1-3

libssl.so.4 is needed by (installed) evolution-1.2.2-4

libssl.so.4 is needed by (installed) imap-2001a-18

openssl is needed by (installed) mod_ssl-2.0.40-21

openssl is needed by (installed) libpcap-0.7.2-1

 

 

ㅡㅇㅡ 어찌해야 하올런지요...

 

아직 처버인지라 소스컴파일 할 줄도 모르고..

 

postgresql7.3 => postgresql 7.2 으로 가는 좋은 방법 어디 없을까요?

 

( 서버에서 프로그램이 따로 돌고 있는데, 아직 postgresql 7.3은

 

지원하지 않습니다.... ㅜ _ ㅜ )

 

만약 소스컴파일을 해야만 한다면..

 

자세한 방법을 알려 주시면 감사하겠습니다..

이 글에 대한 댓글이 총 1건 있습니다.

그냥 단순하고, 가장 일반적인 설치 방법에 대한 소개를 드립니다.

 

설치를 하려면, 먼저

다음이 만족되어야합니다.

  • gnu make 3.76.1 이상
  • C 컴파일러 (거의 대부분의 컴파일러에서 무난히 컴파일됩니다
  • raedline
  • (plpython 기능을 이용하려면, python, plperl 기능을 이용하려면, perl, jdbc를 만드려면, jdk, ant .. nls 기능을 이용하려면, gettext ... 등 여러 가지 패키지들이 필요합니다) - 아무것도 필요없으면, make와 압축풀 gzip, tar, c 컴파일러만 있으면 됩니다 

 

이 글을 하나씩 복사하셔서 그냥 실행시키기만 하면 별 탈 없이 설치가 될겝니다.

 

$ su - 
# mkdir /usr/local/src
# cd /usr/local/src
# wget -O postgresql-7.3.4.tar.gz ftp://linux.sarang.net/.3/postgresql/source/v7.3.4/postgresql-7.3.4.tar.gz
# tar xzf postgresql-7.3.4.tar.gz
# cd postgresql-7.3.4
# ./configure --enable-nls
# make all
# make install
# echo /usr/local/pgsql/lib >> /etc/ld.so.conf
# ldconfig
# useradd -d /usr/local/pgsql postgres
# chown postgres.postgres /usr/local/pgsql
# su - postgres
$ mkdir data
$ chmod 700 data
$ bin/initdb -D /usr/local/pgsql/data -L /usr/local/pgsql/share -E euc-kr --locale=ko_KR.eucKR --lc-collate=C
$ bin/pg_ctl -D /usr/local/pgsql/data -l /usr/local/pgsql/data/error_log start
$ exit
# exit
$ /usr/local/pgsql/bin/psql -U postgres template1

 

성공하시길 빕니다.

김상기(ioseph)님이 2003-09-03 10:47에 작성한 댓글입니다.
이 댓글은 2003-09-03 10:48에 마지막으로 수정되었습니다.
[Top]
No.
제목
작성자
작성일
조회
4888jdbc 이용시 암호의 보안문제 질문입니다. [2]
유욱종
2003-09-03
1854
4886recycled transaction log file xxx 의 우리말
김상기
2003-09-03
1664
4884postgres 윈도우 설치방법을 가르쳐 주세요. [2]
박종선
2003-09-03
2523
4880레드햇 9.0 설치 후 postgresql 구버젼 설치시 문제 [1]
강승진
2003-08-13
3154
4877psql이 실행할때... 어떤 파일을 참조하나요? [2]
장현식
2003-09-02
1845
4875postgresql에도 사용자 변수 선언이 가능한가요? [3]
어리버리
2003-09-02
5272
4873데비안에서 postgresql 설치하는데.. 에러가 나네요... [1]
장현식
2003-09-01
1870
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.017초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다