postgresql 설치

확인1

postgresql 설치 여부를 확인합니다

aptitude show postgresql | grep State
 
 State : not installed

 

 

설치

apt-get install postgresql

 

 

확인2

dpkg -l | grep postgres
 
 
cat /etc/passwd | grep postgres
 
 
/etc/init.d/postgresql status
 
 
netstat -tnlp | grep postgres

 

 

패스워드 설정

sudo -u postgres psql template1
 
 
ALTER USER postgres with encrypted password 'p@ssw0rd';