Hi Firstly apologies but i have to install an app that uses postgres but i am more a MySQL/Oracle guy so i maybe doing something really wrong here.. I am following instructions for creating a DB user and encountering this # createuser -ADP -U postgres foo Enter password for new user: Enter it again: createuser: could not connect to database template1: FATAL: IDENT authentication failed for user "postgres" In a standard postgres install whats causing this? I presume its because the user postgres has a pwd but what is this and why am i not being prompted to enter this? Thanks and apologies as i know this is not directly a CentOS problem
On Tue, Apr 10, 2007 at 12:03:56PM +0100, Tom Brown wrote:> I am following instructions for creating a DB user and encountering this > > # createuser -ADP -U postgres foo > Enter password for new user: > Enter it again: > createuser: could not connect to database template1: FATAL: IDENT > authentication failed for user "postgres"Try instead: sudo -u postgres createuser -ADP foo> In a standard postgres install whats causing this? I presume its because > the user postgres has a pwd but what is this and why am i not being > prompted to enter this?See http://www.postgresql.org/docs/7.4/interactive/client-authentication.html and /var/lib/pgsql/data/pg_hba.conf. -- lfr 0/0 -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: not available URL: <http://lists.centos.org/pipermail/centos/attachments/20070410/620178dd/attachment-0004.sig>
> Try instead: sudo -u postgres createuser -ADP fooThanks - 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