Postgresql

Installation

yum install postgresql

binaries

/usr/bin/clusterdb
/usr/bin/createdb
/usr/bin/createlang
/usr/bin/createuser
/usr/bin/dropdb
/usr/bin/droplang
/usr/bin/dropuser
/usr/bin/pg_config
/usr/bin/pg_dump
/usr/bin/pg_dumpall
/usr/bin/pg_restore
/usr/bin/psql
/usr/bin/reindexdb
/usr/bin/vacuumdb
/usr/lib64/pgsql

init db & on startup

service postgresql initdb

chkconfig postgresql on  
--- or ---
systemctl enable postgresql.service

systemctl start postgresql.service

creating a database

]# sudo -l postgres createdb tt-dev
/bin/postgres createdb tt-dev

drop a database

sudo -l postgres dropdb tt-dev

Create user

create user dbuser with encrypted password 'password';


grant all privileges on database ttdev to dbuser;

revoke all privileges on database ttdev from dbuser;

set remote auth

/var/lib/pgsql/data/pg_hba.conf

Change METHOD ident to md5

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
#host    all             all             127.0.0.1/32            ident
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
#host    all             all             ::1/128                 ident
host    all             all             ::1/128                 md5

connect db


psql -h server -d ttdev -U dbuser -W

Links