[CentOS] postgres 7 - CentOS 4.4

Luciano Miguel Ferreira Rocha strange at nsk.no-ip.org
Tue Apr 10 11:19:23 UTC 2007


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.sig>


More information about the CentOS mailing list