Tom Brown wrote:
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?
probably, you're not using TCP/IP to connect. Read the docs more closely.
--
Cheers
John
-- spambait
1aaaaaaa@xxxxxxxxxxxxxxxx Z1aaaaaaa@xxxxxxxxxxxxxxxx
Please do not reply off-list
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
