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
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
