!!Installazione
- Installare i seguenti pacchetti:
- postgresql
- postgresql-server
%%prettify 
{{{
rcpostgresql start
chkconfig postgresql on

su postgres
psql postgres

postgres=# create user root with superuser login;
CREATE ROLE
postgres=# create user sqlgrey with password 'iehQ6Ffshvta93eP';
CREATE ROLE
postgres=# create database sqlgrey owner sqlgrey;
CREATE DATABASE
postgres=#
}}}
!!!Comandi base
settare uno schema(db2prod):
%%prettify 
{{{
SET search_path TO db2prod,public;
}}}