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

 회원가입

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


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'
yum install readline-devel -y
yum install zlib-devel -y

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
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.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 최길호