PostgreSQL server cannot be added into Plesk: password authentication failed for user "postgres"

Follow

Comments

4 comments

  • Avatar
    Markus Weingärtner

    under Resolution 3. the command have to be 

    ./postgresql.sh

    0
    Comment actions Permalink
  • Avatar
    Alexandr Redikultsev

    Hi @Markus Weingärtner!

    Thank you very much for noticing this!

    I have updated the article.

    0
    Comment actions Permalink
  • Avatar
    Lev Krapivner

    @Alexandr Redikultsev

    getting error

    Finding the proper config...
    Found
    Adding localhost to the list of trusted...
    Done!
    Getting the password from Plesk database...
    PHP Warning: mcrypt_decrypt(): Received initialization vector of size 0, but size 16 is required for this encryption mode in Command line code on line 1
    Done!
    Updating PostgreSQL with the proper password
    ERROR: syntax error at or near "with"
    LINE 1: ALTER USER with password '';
    ^
    Done! Localhost was removed from the list of trusted

     

    0
    Comment actions Permalink
  • Avatar
    Alexandr Redikultsev

    Hi @Lev Krapivner,

    This means that the following select returns empty result:

    select admin_login,admin_password from DatabaseServers where type="postgresql"

    So there is no information regarding postgresql admin user even in Plesk database.

    In this case, I suggest using manual approach in 'For older versions of Plesk' section.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request