Re: [GENERAL] User authentication problem

Guillermo Iglesias wrote:
  >I have a database in a PC with linux and I try to connect from other PC with
  >linux too, when I try to do a query from command line with psql and the -u
  >option :
  >
  >    psql -d obrascop -c "select * from obras" -hpedidos -u
  >
  >I get the following error if i suply an user that exists in /etc/passwd
  >
  >    Connection to database 'obrascop' failed.
  >    Password authentication failed for user 'postgres'
  >
  >But if i connect with an user that only exists in PostgreSQL it works
  >Can someone tell me why
  >
  >I have the following line in pg_hba.conf
  >    host         all         192.168.0.15  255.255.255.255   password
  >where 192.168.0.15  is the host from which I try to connect.

PostgreSQL password authentication has nothing to do with /etc/passwd.

The only users who can access PostgreSQL are those known to it
(listed in pg_shadow).  These usernames bear no necessary connection
with names in /etc/passwd.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Come unto me, all ye that labour and are heavy laden,
      and I will give you rest. Take my yoke upon you, and
      learn of me; for I am meek and lowly in heart; and ye
      shall find rest unto your souls."
                                 Matthew 11:28,29