Crear un usario de base de datos para el usuario de ubuntu: $ sudo su – postgres $ createuser william Shall the new role be a superuser? (y/n) y CREATEROLE $ createuser root Shall the new role be a superuser? (y/n) y CREATEROLE

$ vi /etc/postgresql/8.3/main/pg_hba.conf

1. changed “local all all” and “host all all” lines from ident sameuser to trust

$ exit $ sudo /etc/init.d/postgresql-8.3 restart

It is useful to actually have a password, even using trust, otherwise problems with DBD::Pg pop up telling you that no password was supplied.