root# emerge --sync
root# emerge -a postgresql
        

You will however need to add an entry into /etc/shadow for postgres:

root# echo "postgres::::::::" >> /etc/shadow
        	

root# mkdir -p /path/db/data
root# mkdir -p /path/db/logs
root# chown -R postgres:postgres /path/db
        

PGDATA=/path/db/data
PGLOG=/path/db/logs/postgres.log
PGUSER=postgres

# Uncomment this if you want to support TCP/IP connections
# PGOPTS="-N 1024 -B 2048 -i"
        

root# su - postgres -c 'export PGDATA=/path/db/data && initdb'
        

root# /etc/init.d/postgresql start
        

su - postgres
        

psql# createuser rockfloat
OUTPUT: Shall the new user be allowed to create databases? (y/n) n
OUTPUT: Shall the new user be allowed to create more new users? (y/n) n
psql# psql template1
template1=# alter user rockfloat with password 'foobar';
        OUTPUT: ALTER USER
template1=# \q
--> create the live database        
psql# createdb rockfloat
        OUTPUT: CREATE DATABASE
--> populate it        
psql# psql -e rockfloat < rockfloat.sql

--> create the development db        
psql# createdb rockfloat_monkey
        OUTPUT: CREATE DATABASE
--> populate it        
psql# psql -e rockfloat_monkey < rockfloat.sql

psql# exit
        

user# createdb -E UTF-8 -O postgres -U postgres rockfloat
        

root# rc-update add postgresql default
        

root# su - postgres -c 'pg_dump -c foodatabase > backup.sql'

# Or without using sudo:
user# pg_dump -U postgres foodatabase > backup.sql
        

root# su - postgres -c 'psql -e foodatabase < backup.sql'

# Or without using sudo:
user# psql -e foodatabase postgres < backup.sql
        

root# su - postgres -c 'pg_dump -c -t footable foodatabase > tablebackup.sql'

# Or without using sudo:
user# pg_dump -U postgres -c -t footable foodatabase > tablebackup.sql
        

root# su - postgres -c 'psql -e foodatabase -t footable < tablebackup.sql'

# Or without using sudo:
user# psql -e -t footable foodatabase postgres < tablebackup.sql