postgresql 10 설치

1. 필수 패키지 설치

sudo apt-get install build-essentialsudo 

apt-get install zlib1g-dev libreadline6-dev

 

2. 소스 다운로드

wget https://ftp.postgresql.org/pub/source/v11.1/postgresql-11.1.tar.bz2
tar -xvf postgresql-11.1.tar.bz2

 

3. 소스 컴파일

cd postgresql-11.1
./configure

 

make

make install

 

4. 계정 추가 

adduser postgres

 

5. 퍼미션 변경 및 초기화, 시작

$mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data
$su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &

 

6. 접속 가능 상태 확인

/usr/local/pgsql/bin/psql postgres

 

7. client 설치

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.PostgreSQL.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update

 

sudo apt-get upgrade

 

1) cli 툴 설치

apt-get install postgresql-client-11

 

2) gui 툴 설치

apt-get install pgadmin4

 

*참고 agt-get으로 server 설치할 경우

apt-get install postgresql-11   (설치)

/usr/lib/postgresql/11/bin/pg_ctl -D /var/lib/postgresql/11/main -l logfile start  (시작)