Differences

This shows you the differences between two versions of the page.

--- contrib:pgrouting [2011/09/06 14:46] – [Add PostGIS functions] mainnerebner
+++ contrib:pgrouting [2012/01/06 15:06] – [Setup PostgreSQL] mainnerebner
@@ Line 16: / Line 16: @@
 <code>
 sudo apt-get install build-essential git-core cmake
-sudo apt-get install postgresql-8.4-postgis postgresql-server-dev-8.4
+sudo apt-get install postgresql postgresql-8.4-postgis postgresql-server-dev-8.4
 </code>
@@ Line 55: / Line 55: @@
 Set local database connections to “trust” in “pg_hba.conf” to be able to work with PostgreSQL as user “postgres”. Then restart PostgreSQL.
 <code>
-sudo gedit /etc/postgresql/8.3/main/pg_hba.conf
+sudo gedit /etc/postgresql/8.4/main/pg_hba.conf
-sudo /etc/init.d/postgresql-8.3 restart
+sudo /etc/init.d/postgresql-8.4 restart
+# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
+local    all     all     				trust
+</code>
+==== Start postgresql daemon ====
+<code bash>
+sudo /etc/init.d/postgresql-8.4 start
 </code>
 ==== Create routing database ====
@@ Line 73: / Line 80: @@
 .4:
 <code>
-psql -U postgres -f /usr/share/postgresql-8.4-postgis/postgis.sql routing
+psql -U postgres -f /usr/share/postgresql/8.4/contrib/postgis.sql routing
 psql -U postgres -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql routing
 </code>