Ci-dessous, les différences entre deux révisions de la page.
hackfest2009:serveur-d2 [2009/08/29 23:31] 2001:0:53aa:64c:1cd3:f2:ad08:48b7 créée |
hackfest2009:serveur-d2 [2009/09/14 21:29] (Version actuelle) 81.65.191.231 |
||
---|---|---|---|
Ligne 8: | Ligne 8: | ||
[sudo] password for maposmatic: xxxxxxxxxxxx | [sudo] password for maposmatic: xxxxxxxxxxxx | ||
</code> | </code> | ||
+ | |||
==== PostGIS et Postgresql ==== | ==== PostGIS et Postgresql ==== | ||
Ligne 91: | Ligne 92: | ||
$ sudo -u postgres psql -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql -d maposmatic | $ sudo -u postgres psql -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql -d maposmatic | ||
$ sudo -u postgres psql -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql -d maposmatic | $ sudo -u postgres psql -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql -d maposmatic | ||
+ | $ sudo -u postgres psql -f /usr/share/postgresql/8.3/contrib/_int.sql -d maposmatic # module 'intarray' pour le support des diffs | ||
$ echo "ALTER TABLE geometry_columns OWNER TO maposmatic; ALTER TABLE spatial_ref_sys OWNER TO maposmatic;" | sudo -u postgres psql -d maposmatic | $ echo "ALTER TABLE geometry_columns OWNER TO maposmatic; ALTER TABLE spatial_ref_sys OWNER TO maposmatic;" | sudo -u postgres psql -d maposmatic | ||
</code> | </code> |