Postgres GOD wrote:
  >> Use lines such as
  >> 
  >>   local            all                             password
  >>   host             192.137.23      255.255.255.0   crypt
  >> 
  >> in /etc/postgresql/pg_hba.conf; then you can use
  >> 
  >>    CREATE USER user WITH PASSWORD password...
  >> 
  >
  >thanks for your help. i followed your instructions but can't still connect
  >to my database. btw, i'm using 6.3.2 version. i copied exactly the two
  >lines you've mentioned above in my pg_hba.conf and i even tried modifying
  >using my server's ip but still user authentication failed.
  >
  >what should be the problem with this?

Have you restarted the postmaster after editing pg_hba.conf?
Have you created a password for yourself before trying to connect
using password authentication?

-- 
Oliver Elphick                                [EMAIL PROTECTED]
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Wash me thoroughly from mine iniquity, and cleanse me 
      from my sin. For I acknowledge my transgressions; and 
      my sin is ever before me. Against thee, thee only, 
      have I sinned, and done this evil in thy sight..."
                                   Psalms 51:2-4 


Reply via email to