!!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;
}}}
Connettere a DB:
%%prettify 
{{{
psql -U java  rub35
}}}