HOWTO cartodb in centos 7.3 + posrgresql 9.6


HOWTO cartodb centos 7.3 + posrgresql 9.6


using postgresql 9.6 centos 7.3

wget -c

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 trust" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all cartodb trust" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all publicuser trust" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all tileuser trust" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all all md5" » /var/lib/pgsql/9.6/data/pg_hba.conf
echo "host all all 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 -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 plpgsql -U postgres -d template_postgis

psql -h -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= PGUSER=postgres make installcheck

wget -c
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.