> Try instead: sudo -u postgres createuser -ADP foo Thanks - got further but now i see this # sudo -u postgres psql -f central.sql -q FOO foo psql: FATAL: IDENT authentication failed for user "foo" > See http://www.postgresql.org/docs/7.4/interactive/client-authentication.html > and /var/lib/pgsql/data/pg_hba.conf. I have looked here and my 'trust' lines look like this host all all 127.0.0.1 255.255.255.255 trust host all all 192.168.11.238 255.255.255.255 trust however that issue still occurs - any thoughts? thanks for the help so far