<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Courier New";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 32.35pt 1.0in 32.35pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'>Hi Vince,<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'>If you keep the messages on the list it can help others. I
don't mind you sending it to me directly if you are replying to a post of mine
as I may see it sooner.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'>I generally use the unstable repository as it gets updated
faster (thus unstable). I run on the bleeding edge </span></font><font
face=Wingdings><span style='font-family:Wingdings'>J</span></font><font
face=Arial><span style='font-family:Arial'>.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'>Here is a script which I use to create postgreSQL templates
for a PostGIS database and a pgRouting database. It is a modified version of
one found in the pgRouting site. <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'>It assumes PostGIS version 2 and PostgreSQL may need to be version
9. This works on my setup using Ubuntu 12.04 and PostgreSQL 9.1 and the
ubuntugis-unstable repository to get MapServer and PostGIS.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'>You may need to run to get the “pg_config”
utility which reports various config information for PostgreSQL:<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo apt-get install libpq-dev<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face=Arial><span style='font-size:12.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># /bin/bash <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>#
------------------------------------------------------------------------------<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># Setup template containing PostGIS and/or pgRouting<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>#
------------------------------------------------------------------------------<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>#<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># To create a GIS database as non-superuser run: <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>#<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># "createdb -h hostname -W -T template_postgis mydb<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>#<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># Source:
http://geospatial.nomad-labs.com/2006/12/24/postgis-template-database/<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>#<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># Note: "pg_config" requires "libpq-dev" package<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>if [ -e `pg_config --sharedir` ]<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>then<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "PostGIS installed in"
`pg_config --sharedir`<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> POSTGIS_SQL_PATH=`pg_config
--sharedir`/contrib<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>else<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
POSTGIS_SQL_PATH=/usr/share/postgresql/9.1/contrib/postgis-2.0<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "PostGIS path set as $POSTGIS_SQL_PATH"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>fi<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>ROUTING_SQL_PATH=/usr/share/postlbs<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># Create "template_postgis"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># -------------------------<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>if sudo -u postgres psql --list | grep -q template_postgis ;<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>then<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "PostGIS template already
exists!"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>else<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "Create PostGIS template ..."<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> VERSION=$(basename $(pg_config --sharedir))<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "PostgreSQL version is $VERSION"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> if [ $VERSION \< 9.1 ];<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> then<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> # for PostgreSQL less than 9.1<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres createdb -<st1:place w:st="on">E
UTF8</st1:place> -T template0 template_postgis<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres createlang -d template_postgis
plpgsql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $POSTGIS_SQL_PATH/postgis.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $POSTGIS_SQL_PATH/spatial_ref_sys.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $POSTGIS_SQL_PATH/postgis_comments.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $POSTGIS_SQL_PATH/postgis-2.0/rtpostgis.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \ <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $POSTGIS_SQL_PATH/postgis-2.0/raster_comments.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $POSTGIS_SQL_PATH/postgis-2.0/topology.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $POSTGIS_SQL_PATH/postgis-2.0/topology_comments.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-c
"GRANT ALL ON geometry_columns TO PUBLIC;"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-c "GRANT ALL ON geography_columns TO PUBLIC;"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis -c
"VACUUM FULL;"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_postgis -c
"VACUUM FREEZE;"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> else<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> # for PostgreSQL 9.1+<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres createdb -<st1:place w:st="on">E
UTF8</st1:place> -T template0 template_postgis<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql -d template_postgis -c
"CREATE EXTENSION postgis"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql -d template_postgis -c
"CREATE EXTENSION postgis_topology"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> fi<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d postgres \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> -c "UPDATE pg_database SET
datistemplate='true' WHERE datname='template_postgis';"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d postgres \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> -c "UPDATE pg_database SET
datallowconn='false' WHERE datname='template_postgis';"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "... template_postgis created."<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>fi<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># Create "template_routing"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'># -------------------------<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>if sudo -u postgres psql --list | grep -q template_routing ;<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>then<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "pgRouting template already exists!"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>else<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "Create pgRouting template ..."<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres createdb -<st1:place w:st="on">E UTF8</st1:place>
-T template_postgis template_routing<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $ROUTING_SQL_PATH/routing_core.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $ROUTING_SQL_PATH/routing_core_wrappers.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $ROUTING_SQL_PATH/routing_topology.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $ROUTING_SQL_PATH/routing_tsp.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $ROUTING_SQL_PATH/routing_tsp_wrappers.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $ROUTING_SQL_PATH/routing_dd.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $ROUTING_SQL_PATH/routing_dd_wrappers.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>
-f $ROUTING_SQL_PATH/matching.sql<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing -c
"VACUUM FULL;"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d template_routing -c
"VACUUM FREEZE;"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d postgres \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> -c "UPDATE pg_database SET
datistemplate='true' WHERE datname='template_routing';"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> sudo -u postgres psql --quiet -d postgres \<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> -c "UPDATE pg_database SET
datallowconn='false' WHERE datname='template_routing';"<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'> echo "... template_routing created."<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>fi<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>#-------------------------------------------------------------------------<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>I hope this helps.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=3 face="Courier New"><span style='font-size:
12.0pt'>Worth<o:p></o:p></span></font></p>
</div>
</body>
</html>