Changes
Jump to navigation
Jump to search
Database Server Documentation (view source)
Revision as of 18:28, 14 March 2016
, 18:28, 14 March 2016no edit summary
Log on to the box as root then:
groupadd -g 112 postgres
useradd -g postgres -s /bin/bash -p xxxx -d /home/postgres -m postgres
passwd postgres
mkdir /var/postgresql/data
chown postgres /var/postgresql/data
Change to postgres and initialize the dbase
su postgres
cd /usr/lib/postgresql/9.5/bin/
./initdb -D /var/postgresql/data
To work as the postgres account.