<div dir="ltr">Howdy,<div><br></div><div>I am currently using your `postgresql-9.3-postgis-2.1` debian package. My team and I upgrading our RoR app to Rails 4, and we keep throwing the same error when attempting to create a database.</div>
<div><br></div><div><pre class="" style="margin-top:0px;margin-bottom:10px;padding:5px;border:0px;font-size:14px;vertical-align:baseline;background-color:rgb(238,238,238);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;overflow:auto;width:auto;max-height:600px;word-wrap:normal;color:rgb(0,0,0);line-height:17.804800033569336px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">PG</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">::</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(43,145,175)">RaiseException</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> ERROR</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(43,145,175)">PostGIS</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> is already installed </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(0,0,139)">in</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> schema </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">'public'</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> uninstall it first </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> CREATE EXTENSION postgis SCHEMA public</span></code></pre>
<div><code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"><br>
</span></code></div><div><code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">For more information including my installation steps, please refer to my question on stackoverflow:</span></code></div>
<div><code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"><br>
</span></code></div><div><code style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"><font face="Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, Courier New, monospace, serif"><a href="http://stackoverflow.com/questions/22947838/postgis-error-when-upgrading-to-rails-4">http://stackoverflow.com/questions/22947838/postgis-error-when-upgrading-to-rails-4</a></font><br>
</span></code></div><div><code style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"><font face="Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, Courier New, monospace, serif"><br>
</font></span></code></div><div>I think this installation line might be conflicting with Rails:</div><div><br></div><div><pre class="" style="margin-top:0px;margin-bottom:10px;padding:5px;border:0px;font-size:14px;vertical-align:baseline;background-color:rgb(238,238,238);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;overflow:auto;width:auto;max-height:600px;word-wrap:normal;color:rgb(0,0,0);line-height:17.804800033569336px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">sudo </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">-</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">u postgres psql </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">-</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">d template_postgis </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">-</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">f </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">/</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">usr</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">/</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">share</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">/</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">postgresql</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">/</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">9.3</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">/</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">extension</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">/</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">postgis</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">--</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">2.1</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">2.sql</span></code></pre>
</div><div><div dir="ltr"><br></div><div dir="ltr"><h1 style="font-family:Arial;background-color:rgb(255,255,255);color:rgb(33,162,249);font-size:17px;font-weight:normal;line-height:8px;margin:0px"></h1>Any suggestions on how to resolve? </div>
<div dir="ltr"><br></div><div>Cheers,</div><div>Jake</div><div dir="ltr"><hr width="600px" align="left" height="1px" color="#21a2f9" style="border-right-width:0px;border-bottom-width:0px;border-left-width:0px;min-height:0px;border-top-style:solid;border-top-color:rgba(0,0,0,0.0980392);color:rgb(85,85,85);font-family:Arial;font-size:10px;line-height:12px">
<br style="background-color:rgb(255,255,255);line-height:12px;color:rgb(85,85,85);font-size:10px;font-family:Arial"><h1 style="background-color:rgb(255,255,255);line-height:4px;color:rgb(33,162,249);font-size:15px;margin:0px;font-family:Arial;font-weight:normal">
Jake O'Brien Fagan</h1><p style="background-color:rgb(255,255,255);line-height:13px;color:rgb(85,85,85);font-size:10px;font-family:Arial">Development Operations Engineer<br><a href="http://www.househappy.org/" style="color:rgb(33,162,249)" target="_blank">househappy.org</a><br>
<a href="https://www.facebook.com/househappy.org" style="color:rgb(33,162,249)" target="_blank"><font color="#555555">Facebook</font></a><font color="#555555"> |</font> <a href="https://twitter.com/househappy" style="color:rgb(33,162,249)" target="_blank"><font color="#555555">Twitter</font></a><font color="#555555"> |</font> <a href="http://instagram.com/househappy" style="color:rgb(33,162,249)" target="_blank"><font color="#555555">Instagram</font></a></p>
<table border="0" cellpadding="0" cellspacing="0" width="600" style="color:rgb(34,34,34);text-align:start;font-size:13px;font-family:arial,sans-serif;border:0px solid rgb(221,221,221)"><tbody><tr style="font-family:Times">
<td align="center" valign="top" style="font-family:arial,sans-serif;margin:0px;border-collapse:collapse"><br></td></tr><tr style="font-family:Times"><td align="center" valign="top" style="font-family:arial,sans-serif;margin:0px;border-collapse:collapse">
<br></td></tr></tbody></table></div></div>
</div></div>