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

 회원가입

source make install [ 8 ~ 14 ]
최길호 [LIST]   2021-11-11 23:57:54, 조회 : 171


https://ftp.postgresql.org/pub/source/

wget https://ftp.postgresql.org/pub/source/v8.4.22/postgresql-8.4.22.tar.gz

# cat /etc/redhat-release
CentOS release 6.10 (Final)

root#
# 사전 설치
yum groupinstall 'Development Tools'

su - postgres
gunzip postgresql-14.1.tar.gz
gunzip postgresql-13.4.tar.gz
gunzip postgresql-12.8.tar.gz
gunzip postgresql-11.13.tar.gz
gunzip postgresql-10.18.tar.gz
gunzip postgresql-9.6.23.tar.gz
gunzip postgresql-8.4.22.tar.gz # 2014/7/22 완료

설치는 모두 동일
tar xf postgresql-8.4.22.tar
cd     postgresql-8.4.22

./configure --prefix=/psql/8.4.22 --with-pgport=5408
make

root#
cd /psql/postgresql-8.4.22
make install
# install extention
cd contrib
make install
설치 위치
dirname `which psql` # psql 위치 확인
/psql/[9~14]/bin [ bin 설치 위치 ]
설치 위치 share/postgresql/contrib/ or share/postgresql/extension/
/psql/[8]/share/postgresql/contrib/
/psql/[9~14]/share/postgresql/extension/



# DB 설치 사전 생성
mkdir /psql/8.4.22/data
chown postgres:postgres /psql/8.4.22/data

# 설치 정보 확인
/psql/8.4.22/bin/pg_config --configure
'--prefix=/psql/8.4.22' '--with-pgport=5408'

/usr/bin/pg_config --configure
'--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--target=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--disable-rpath' '--with-perl' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-python' '--with-ldap' '--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' '--with-ossp-uuid' '--with-libxml' '--with-libxslt' '--enable-nls' '--enable-dtrace' '--enable-thread-safety' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--datadir=/usr/share/pgsql' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'target_alias=x86_64-redhat-linux-gnu' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DLINUX_OOM_ADJ=0'


### binary 파일에 위치,포트등이 모두 저장되어 있다.
/psql/8.4.22/bin/psql
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5408"?

strings /psql/8.4.22/bin/psql | egrep "PORT|54"
============================================
PGPORT
5408

strings /psql/8.4.22/bin/psql | grep "/psql"
============================================
/psql/8.4.22/lib
/psql/8.4.22/bin
/psql/8.4.22/share/postgresql
/psql/8.4.22/etc/postgresql
/psql/8.4.22/include
/psql/8.4.22/lib
/psql/8.4.22/lib/postgresql
/psql/8.4.22/share/locale
/psql/8.4.22/share/man
/psql/8.4.22/include/postgresql
/psql/8.4.22/include/postgresql/server
/psql/8.4.22/share/doc//postgresql


su - postgres
export PATH=/psql/9.6.23/bin:$PATH
export PGDATA=/psql/9.6.23/data

initdb -D $PGDATA
pg_ctl -D $PGDATA -l $PGDATA/logfile start

cat >> .bash_profile
# for 8.4.22
alias psql8='
export PATH=/psql/8.4.22/bin:$PATH
export PGDATA=/psql/8.4.22/data
export PGPORT=5408
'
# for 9.6.23
alias psql9='
export PATH=/psql/9.6.23/bin:$PATH
export PGDATA=/psql/9.6.23/data
export PGPORT=5409
'
# for 10.18
alias psql10='
export PATH=/psql/10.18/bin:$PATH
export PGDATA=/psql/10.18/data
export PGPORT=5410
'
# for 11.13
alias psql11='
export PATH=/psql/11.13/bin:$PATH
export PGDATA=/psql/11.13/data
export PGPORT=5411
'
# for 12.8
alias psql12='
export PATH=/psql/12.8/bin:$PATH
export PGDATA=/psql/12.8/data
export PGPORT=5412
'
# for 13.4
alias psql13='
export PATH=/psql/13.4/bin:$PATH
export PGDATA=/psql/13.4/data
export PGPORT=5413
'
# for 14.1
alias psql14='
# for 14.1
export PATH=/psql/14.1/bin:$PATH
export PGDATA=/psql/14.1/data
export PGPORT=5414
'

echo '
# for 8.4.20
export PATH=/usr/bin:$PATH
export PGDATA=/var/lib/pgsql/data
# for 8.4.22
export PATH=/psql/8.4.22/bin:$PATH
export PGDATA=/psql/8.4.22/data
export PGPORT=5408
# for 9.6.23
export PATH=/psql/9.6.23/bin:$PATH
export PGDATA=/psql/9.6.23/data
export PGPORT=5409
# for 10.18
export PATH=/psql/10.18/bin:$PATH
export PGDATA=/psql/10.18/data
export PGPORT=5410
# for 11.13
export PATH=/psql/11.13/bin:$PATH
export PGDATA=/psql/11.13/data
export PGPORT=5411
# for 12.8
export PATH=/psql/12.8/bin:$PATH
export PGDATA=/psql/12.8/data
export PGPORT=5412
# for 13.4
export PATH=/psql/13.4/bin:$PATH
export PGDATA=/psql/13.4/data
export PGPORT=5413
# for 14.1
export PATH=/psql/14.1/bin:$PATH
export PGDATA=/psql/14.1/data
export PGPORT=5414
'

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 186
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 117
Admin  source make install [ 8 ~ 14 ]    최길호 2021/11/11 171
Admin  psql odbc make install    최길호 2021/11/09 135
Admin  oracle to psql dblink    최길호 2021/11/09 156
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 206
Admin  pg_dumpall pg_upgrade    최길호 2021/10/21 149
Admin  통계정보    최길호 2021/10/21 125
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 236
Admin  psql dblink to oracle [ odbc test ] 한글    최길호 2021/04/19 2499
Admin  postgres , enterprisedb(EDB) / [ ERROR: type "number" does not exist ]    최길호 2020/09/01 273
Admin  install postgresql on docker centos:7    최길호 2020/08/31 383
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 최길호