Product SiteDocumentation Site

2. PostgreSQL 9.1

We'll install PostgreSQL first, we don't need to edit the repository because Fedora 16 comes with PostgreSQL 9.1
yum install postgresql postgresql-server postgresql-libs postgresql-devel postgresql-contrib
Enable PostgreSQL at boot:
systemctl enable postgresql.service
Initialize PostgreSQL:
postgresql-setup initdb
Start PostgreSQL:
systemctl start postgresql.service
Create postgresql admin user
su postgres
createuser -e -P -s <adminuser>
exit
Edit /var/lib/pgsql/data/pg_hba.conf
...
# "local" is for Unix domain socket connections only
#local   all             all                                     peer
local   all             all                                     md5
# 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
...
Restart PostgreSQL:
systemctl restart postgresql.service