설치/기본사용.우분투

1) sudo apt-get install postgresql postgresql-contrib

 

2) psql --version

 

3) > sudo -i -u postgres

> psql

 

혹은

> sudo -u postgres psql

 

4) 사용자

psql # create user service;

psql # drop user service;

psql # create role service superuser; # drop role service;

psql # \du

psql # \q

 

5) 데이타베이스

psql # create database service4loadtest;

psql # \list