1 Install PostgreSQL in your computer
The distributive of PostgreSQL database can be download from
PostgreSQL site
For download of the latest version of PostgreSQL, use
Postgres
download page
Detailed installations guides on variaty of languages, see at
Installation
guide
2 Create CERIF environment
- Login under postgres user account (or from your account -
sudo -u postgres bash)
- create database for CERIF createdb cerif
- create database user for cerif from unix shell type psql
cerif, then in psql prompt type create user cerif with
password 'PASSWORD'
3 Install CERIF database
- using psql utility. In the unix shell type psql cerif,
then in psql shell type \i PATH/postgres.sql
- OR using pg_restore utility. In the unix shell type
pg_restore -d cerif -F t PATH/cerif_postgres.dmp
|