#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0

    Password authentication failed


    I had version 9.2 and upgraded to 9.2.4, by complete deinstall 9.2 and make a new 9.2.4 installation. I recreated the login role "u_finance" with same password as before, then I made a restore of the 9.2 backup. All works fine except for one issue: when trying to connect from my java application with user u_finance , the following exception occurs:


    2013-06-19 08:24:19 CEST FATAL: password authentication failed for user "u_finance"

    I didn't change anything on the java side. When using user "postgres" for login within java, then all works fine.

    Was there anything changed since 9.2.4 regarding logins ?

    thanks,

    Frank
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Location
    Usually Japan when not on contract
    Posts
    240
    Rep Power
    12
    Did you set up the u_finance role and adjust the new Postgres installation's pg_hba.conf? (usually somewhere like /var/lib/pgsql/9.2/data/pg_hba.conf)
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0

    No change to pg_hba.conf


    I didn't change anything in the file pg_hba.conf. Should I change something ?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Location
    Usually Japan when not on contract
    Posts
    240
    Rep Power
    12
    You almost definitely need to make changes to the default pg_hba.conf. Postgres actually has some of the best documentation of any software around anywhere (open source or otherwise). check it out.

    And don't stop at that link. If you start from the beginning you'll learn a ton of fascinating stuff not just about what Postgres can do, but about how to really use a database in general. In fact, reading the Postgres docs in their entirety often acts like the red pill on developers and might leave you scratching your head at the insane trash many (these days most?) developer tribes do to make their data sorta-kinda work through Database Agnostic Framework X.

IMN logo majestic logo threadwatch logo seochat tools logo