/ Register

Want more timely Centmin Mod News Updates?
Become a Member

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:
Previous Thread Next Thread
Loading...
  1. Sep 19, 2015 #1
    eva2000

    eva2000 Administrator Staff Member

    54,860
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    6:59 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Feb 24, 2016 #2
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    10:59 AM
    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. Feb 24, 2016 #3
    eva2000

    eva2000 Administrator Staff Member

    54,860
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    6:59 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Feb 24, 2016 #4
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    10:59 AM
    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. Feb 25, 2016 #5
    eva2000

    eva2000 Administrator Staff Member

    54,860
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    6:59 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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 :)
     
Previous Thread Next Thread
Loading...

.