Learn about Centmin Mod LEMP Stack today
Register Now

Beta Branch Add POSTGRESQL=n option to centmin.sh for 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Sep 19, 2015.

Tags:
  1. eva2000

    eva2000 Administrator Staff Member

    30,994
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,424
    Local Time:
    8:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    Add POSTGRESQL=n option to centmin.sh for 123.09beta01

    When centmin.sh variable is set to POSTGRESQL=y and you run centmin.sh menu option 5 to recompile PHP server, it will install PostgreSQL 9.4 server and devel yum packages from official PostgreSQL YUM repository at http://yum.postgresql.org/ if not already installed and then append to PHP-FPM configuration options the --with-pdo-pgsql=/usr/pgsql-9.4 configure option to enable and install pdo-pgsql PHP driver extension to allow PHP to communicate with PostgreSQL server.

    To allow to persist on centmin mod code updates, create persistent config file at /etc/centminmod/custom_config.inc and add to it the line:

    POSTGRESQL=y

    Continue reading...

    123.09beta01 branch
     
  2. negative

    negative Member

    217
    22
    18
    Apr 11, 2015
    Ratings:
    +50
    Local Time:
    12:11 PM
    1.9.10
    10.1.11
    Today, i need to install POSTGRESQL service on my server for a website.

    I recompile the php after POSTGRESQL=y parameter in custom_config.inc and it installed postgresql server i think but when i type "psql" command on ssh, i can't connect the psql server still.

    So, do i need install the postgresql server separately ? @eva2000

    I found that document but it may not need to apply
    How To Install and Use PostgreSQL on CentOS 7 | DigitalOcean

    Can you please explain that how can i use the postgresql server healthy ?
     
  3. eva2000

    eva2000 Administrator Staff Member

    30,994
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,424
    Local Time:
    8:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    postgresql server install is taken care of see above commit Add POSTGRESQL=n option to centmin.sh for 123.09beta01 · centminmod/centminmod@fac86b3 · GitHub
    as to how to use postgresql that's left to end user to figure out - i don't provide support for how to use or administer postgresql
     
  4. negative

    negative Member

    217
    22
    18
    Apr 11, 2015
    Ratings:
    +50
    Local Time:
    12:11 PM
    1.9.10
    10.1.11
    This is sad because there are no any postgreSQL article on centminmod community. I wish to see some articles about that :)

    Because i worry about that if i install somethings from external sources or manually, centmin may break in next. So, everything should be integrated with centmin it is most healthy :)

    Thanks anyway
     
  5. eva2000

    eva2000 Administrator Staff Member

    30,994
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,424
    Local Time:
    8:11 PM
    Nginx 1.13.x
    MariaDB 5.5
    Postgresql should be installed from official repo when POSTGRESQL=y is used. Just knowing how to use it Postgresql is up to you. Just as Centmin Mod provides LEMP stack but end user installing their drupal, wordpress, woocommerce, or forum web apps would need to also know how to use those apps :)