-
PostgreSQL 설치 -> DB 생성Flower in my dev/PostgreSQL 2015. 4. 6. 11:45
On CentOS 6.6
yum -y install postgresql-server
service postgresql initdb
service postgresql start
cd /var/lib/pgsql/data/
vi pg_hba.conf
vi postgresql.conf
service postgresql restart
iptables -A INPUT -p tcp --sport 5432 -j ACCEPT
service iptables restart
su - postgres
psql postgres
alter user postgres password 'qwe123'
create user flower with password 'qwe123';
create database testDB with encoding='utf-8' owner flower;
'Flower in my dev > PostgreSQL' 카테고리의 다른 글
<PSQL> [psAdmin4 설치] (0) 2016.10.21 <PSQL> [간단명령어] (0) 2016.09.07 <PSQL> [DB스키마 & 테이블 확인] (0) 2016.09.07 <우분투> postgresql 설치 및 설정 (0) 2016.04.05 Windows에서 접속 (0) 2015.04.06