If you got issue with the Postgres DB I can recommend trying : http://www.pgadmin.org/
The code for making ICAT (the iRODS database) :
-- DROP DATABASE "ICAT"; ( please Note : IF ANY )
CREATE DATABASE "ICAT"
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
CONNECTION LIMIT = -1;
GRANT CONNECT, TEMPORARY ON DATABASE "ICAT" TO public;
GRANT ALL ON DATABASE "ICAT" TO postgres;
GRANT ALL ON DATABASE "ICAT" TO irods;
Then run (in BASH):
/var/lib/irods/packaging/setup_irods.sh ; iinit
