VG написа: > Hi, > > I have installed postgresql-serve using yum > hba.conf group and owner were postgres then i changed it to root.
Why? > > when i type psql -U postgres command ( as root user) I get: > > psql: FATAL: Ident authentication failed for user "postgres" Most probably the default pg_hba.conf includes the following line: local all postgres ident Which means that you could login with the DB user "postgres" only if you are logged in already as the system user "postgres". So "su - postgres" before using psql should do the trick. Please read "Chapter 21. Client Authentication" (http://www.postgresql.org/docs/current/static/client-authentication.html) for details. -- Milen A. Radev -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
