HOWTO cartodb in centos 7.3 + posrgresql 9.6

..

HOWTO cartodb centos 7.3 + posrgresql 9.6

guide: https://github.com/pasing/cartodb-install-centos7.x/blob/master/INSTALL-CARTODB.md

tips:
using postgresql 9.6 centos 7.3

wget -c https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm

yum -y localinstall pgdg-centos96-9.6-3.noarch.rpm
yum -y install postgresql96-server postgresql96 postgresql96-contrib postgresql96-devel postgresql96-libs postgresql-jdbc postgresql96-odbc
yum -y install pg_top96 pgbadger pgadmin3_96 pgadmin4 pgadmin4-web pgagent_96
yum -y install pgbconsole pgaudit_96 pgbouncer pgcenter nagios-plugins-pgactivity.noarch pgmemcache-96 pgpool-II-96 pgpool-II-96-devel pgpool-II-96-extensions pgpool-ha pgrouting_96 postgresql-jdbc-javadoc prefix96 slony1-96 skytools-96 skytools-96-modules repmgr96 split_postgres_dump pgbackrest postgresql96-python postgresql96-plpython

/usr/pgsql-9.6/bin/postgresql96-setup initdb
chkconfig postgresql-9.6 on
service postgresql-9.6 restart

## edit pg_hba.conf
#comment all and add how you whould like
echo "host all postgres 127.0.0.1/32 trust" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all cartodb 127.0.0.1/32 trust" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all publicuser 127.0.0.1/32 trust" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all tileuser 127.0.0.1/32 trust" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all all 192.168.1.0/24 md5" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all all 192.168.0.0/16 md5" » /var/lib/pgsql/9.6/data/pg_hba.conf

yum -y remove CGAL SFCGAL SFCGAL-libs django-htmlmin gdal gdal-devel gdal-libs gdal-python geos geos-devel geos-python libgeotiff nagios-plugins-pgactivity pg_top96 pgadmin3_96 pgadmin4-v1 pgadmin4-v1-docs pgadmin4-v1-web pgagent_96 pgaudit_96 pgbackrest pgbadger pgbconsole pgbouncer pgcenter pgdg-centos96 pgmemcache-96 pgpool-II-96 pgpool-II-96-devel pgpool-II-96-extensions pgpool-ha pgrouting_96 plpgsql_check_96 postgis2_96 postgis2_96-client postgis2_96-devel postgis2_96-utils postgresql-jdbc postgresql-jdbc-javadoc postgresql96 postgresql96-contrib postgresql96-devel postgresql96-libs postgresql96-odbc postgresql96-plpython postgresql96-python postgresql96-server prefix96 python-babel python-beautifulsoup4 python-blinker python-dateutil python-fixtures python-flask python-flask-babel python-flask-gravatar python-flask-login python-flask-mail python-flask-principal python-flask-security python-flask-sqlalchemy python-flask-wtf python-itsdangerous python-jinja2 python-markupsafe python-mimeparse python-psycopg2 python-pyrsistent python-sqlalchemy python-sqlparse python-werkzeug python-wsgiref python-wtforms pytz repmgr96 skytools-96 skytools-96-modules slony1-96 split_postgres_dump

createdb -h 127.0.0.1 -T template0 -O postgres -U postgres -E UTF8 template_postgis

  1. on sql query #CREATE DATABASE template_postgis WITH ENCODING='UTF8' TEMPLATE=template0 CONNECTION LIMIT=-1 TABLESPACE=pg_default;

createlang -h 127.0.0.1 plpgsql -U postgres -d template_postgis

psql -h 127.0.0.1 -U postgres template_postgis -c 'CREATE EXTENSION postgis;CREATE EXTENSION postgis_topology;'

Run an installcheck to verify the database has been installed properly

#PGUSER=postgres make installcheck
PGSSLMODE=disable PGHOST=127.0.0.1 PGUSER=postgres make installcheck

#wget http://download.redis.io/releases/redis-3.2.0.tar.gz
wget -c http://rpms.famillecollet.com/enterprise/7/remi/x86_64/redis-3.2.6-1.el7.remi.x86_64.rpm
yum install redis-3.2.6-1.el7.remi.x86_64.rpm

Unless otherwise stated, the content of this page is licensed under GNU Free Documentation License.