# postgres
sudo apt-get install postgres-sql
sudo apt-get install postgis
# git
sudo apt-get install git
sudo apt-get install libpq-dev python-dev mercurial
sudo apt-get install ant
sudo apt-get install sun-java6-jdk
sudo apt-get -f install jsvc
cd dep/
wget http://github.com/downloads/ringo/ringojs/ringojs_0.8-1_all.deb
dpkg ringojs_0.8-1_all.deb
sudo adduser grace
cd /srv/www/grace
sudo mkdir -p /srv/www/grace/prod
sudo chown -R grace:grace prod/
sudo apt-get install rabbitmq-server
sudo rabbitmqctl add_user talendjobs secret
sudo rabbitmqctl add_vhost /jobs
sudo rabbitmqctl set_permissions -p /jobs talendjobs "" ".*" ".*
sudo apt-get install gdal
sudo su - grace
cd /srv/www/grace/prod/
git clone ssh://jpc@cgit.makina-corpus.net/var/git/grace/geobi-grace-django.git
mkdir dep
sudo mkdir dep
sudo wget https://launchpad.net/~georepublic/+archive/pgrouting/+files/postgresql-8.4-pgrouting_1.05-1~lucid1_amd64.deb
sudo apt-get install postgresql-8.4-postgis
sudo dpkg -i postgresql-8.4-pgrouting_1.05-1~lucid1_amd64.deb
apt-get install tomcat6
apt-get install unzip
cd /var/lib/tomcat6/webapps/
sudo wget http://sourceforge.net/projects/geoserver/files/GeoServer/2.1.4/geoserver-2.1.4-war.zip
sudo unzip geoserver-2.1.4-war.zip
sudo cp geoserver.war /var/lib/tomcat6/webapps/
sudo wget http://sourceforge.net/projects/geonetwork/files/GeoNetwork_opensource/v2.6.4/geonetwork.war/download
sudo cp geonetwork.war /var/lib/tomcat6/webapps/
cd /srv/www/grace/prod/geobi-grace-django/
sudo python bootsrap -d
pg_dropcluster --stop 8.4 main
locale-gen fr_FR.UTF-8
pg_createcluster --locale fr_FR.UTF-8 --start 8.4 main
su postgres -c "/srv/www/grace/prod/geobi-grace-django/scripts/create_template_postgis-debian.sh"
Modif postgres voir séquence ci-dessous
La partie Postgres est intégrée dans un script qui rebuilde tout depuis le début
Warning
ce script détruit et ré-initialise complètement le cluster
/files/build_cluster.sh
#!/bin/bash
pg_dropcluster --stop 8.4 main
pg_createcluster --locale fr_FR.UTF-8 --start 8.4 main
su - postgres -c "/srv/www/grace/prod/geobi-grace-django/scripts/create_template_postgis-debian.sh"
su - postgres -c"createdb -T template_postgis geonode"
su - postgres -c"createdb -T template_postgis grace"
su - postgres -c "createuser -P geonode"
su - postgres -c"psql -c'ALTER DATABASE geonode OWNER TO geonode'"
su - postgres -c"psql -c'ALTER DATABASE grace OWNER TO geonode'"
su - postgres -c"psql -d grace -f /srv/www/grace/prod/geobi-grace-django/sql/insee.sql"
su - postgres -c"psql -d grace -f /home/makina/grace.sql"
su - postgres -c"psql -d grace -f /home/makina/grace_sig.sql"
su - postgres -c"psql -d grace -f /srv/www/grace/prod/geobi-grace-django/sql/grace_49.sql"
su - postgres -c"psql -d grace -f /srv/www/grace/prod/geobi-grace-django/sql/grace_modif_base.sql"
echo 'done'