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 at coco.merseine.nu Z1aaaaaaa at coco.merseine.nu Please do not reply off-list