How to install and initialize PostgreSQL in Plesk

Follow

Comments

9 comments

  • Avatar
    Vivo forta (Edited )

    This procedure has installed PostgreSQL 9.2 on Plesk onyx with centOS 7.3
    How to install PostgreSQL 9.5 or 9.6?

  • Avatar
    Bulat Tsydenov

    @Vivo, PostgreSQL is installed from the repositories enabled on the server. You can enable any other repository which provides the required version of PostgreSQL and install it the same way.

  • Avatar
    Vitaly Zhidkov

    @Vivo, you should enable a corresponding repo for it. Check their list at https://yum.postgresql.org/

  • Avatar
    Peter

    Can someone please tell me how to add PostgreSQL 9.5 repo so i get 9.5 when i install in Plesk GUI?

  • Avatar
    Ivan Postnikov

    @Peter

    Hello!

    Use the following instructions: for Debian, for CentOS.
    In case of any issues regarding setting the PostreSQL, contact support.

  • Avatar
    Ashkan Nasiri

    This file doesn't exist:

    /opt/psa/admin/bin/pg_manage 

    or /opt/psa directory in first place.

  • Avatar
    Ivan Postnikov

    @Ashkan

    As it is written in the article, /opt/psa/admin/bin/pg_manage is a symbolic link to /usr/local/psa/admin/sbin/wrapper. It may be recreated using the command:

    ln -s /usr/local/psa/admin/sbin/wrapper /opt/psa/admin/bin/pg_manage

    Have you tried this command?

    What version of Plesk is installed?

  • Avatar
    Ashkan Nasiri

    We have already ran the ln command but since the file didn't exist we got error. here is the result:

    ln: failed to create symbolic link ‘/opt/psa/admin/bin/pg_manage’: No such file or directory 

     

    We have latest plesk onyx version. It's a fresh installation of plesk.

  • Avatar
    Alexandr Tumanov

    @Ashkan, I've made some corrections to the article. Please check. The path was Ubuntu specific, now it is for all OSes. 

Please sign in to leave a comment.

Have more questions? Submit a request