10 Apr
2007
10 Apr
'07
2:40 p.m.
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@coco.merseine.nu Z1aaaaaaa@coco.merseine.nu
Please do not reply off-list