<div dir="ltr"><div class="gmail_default"><span style="font-family:arial,helvetica,sans-serif">I think the brew installation under </span><font face="courier new, monospace">/Cellar/postgresql</font><font face="arial, helvetica, sans-serif"> is fine. The `psql` and `createdb` under </font><font face="courier new, monospace">/usr/local/bin</font><font face="arial, helvetica, sans-serif"> are just </font><b style="font-family:arial,helvetica,sans-serif">symbolic links</b><font face="arial, helvetica, sans-serif"> created by homebrew during the installation. (See, when you use psql, the default extension directory is under Cellar/postgresql, so at least the postgresql installation is running properly.)</font></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default"><span style="font-family:arial,helvetica,sans-serif">Since the terminal prompts that `postgis.control` is missing, you'll need to check why those files are not found in the directory where they're supposed to be (in your case, </span><font face="courier new, monospace">/usr/local/Cellar/postgresql/9.3.5_1/share/postgresql/extensions/</font><font face="arial, helvetica, sans-serif">).</font></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">If you're not sure, maybe reinstalling postgis would help, use `brew uninstall postgis` then `brew install postgis`.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">If the problems still exists, try copy the extension control file to the expected directories manually.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">PostGIS and pgRouting are just extensions. If your PostgreSQL works fine, you are not far away from success.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 21, 2014 at 9:23 AM, Danqing Zhang <span dir="ltr"><<a href="mailto:danqing0703@berkeley.edu" target="_blank">danqing0703@berkeley.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I tried 'which psql' and they are shown as below:<div><div>
<p><span>danqing0703</span><span>@</span><span>Danqings-MacBook-Pro:</span><span>~</span><span>$ which psql</span></p>
<p><span>/usr/local/bin/psql</span></p>
<p><span>danqing0703</span><span>@</span><span>Danqings-MacBook-Pro:</span><span>~</span><span>$ which createdb</span></p>
<p><span>/usr/local/bin/createdb</span></p><p><span><br></span></p><p><span>but in the </span>/usr/local/Cellar/postgresql/9.3.5_1/share/postgresql/bin folder, there are also createdb,psql etc...I am really confused and stuck on this step. Thanks for the help!</p><p> <img src="cid:ii_149304b648446b73" alt="Inline image 1" width="472" height="309"></p>
</div></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 20, 2014 at 6:18 PM, Danqing Zhang <span dir="ltr"><<a href="mailto:danqing0703@berkeley.edu" target="_blank">danqing0703@berkeley.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi All<div><br></div><div>I have the same problem again with postgis using homebrew:</div><div><br></div><div>I successfully installed postgresql,and installed postgis(just 'brew install postgis'), then I created a database and typed pgsql, I tried to create extension postgis but failed, the output is as below:</div><img src="cid:ii_14930474a59d17aa" alt="Inline image 1" width="472" height="110"><div><br></div><div><br></div><div>I encountered this problem previously and this caused me to use Postgres.app....could anyone give me some link to solve this for I searched online and could not get the reasonable solution, many thanks!</div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 20, 2014 at 9:45 AM, Thomas Cioppettini <span dir="ltr"><<a href="mailto:tom@tecrails.com" target="_blank">tom@tecrails.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><a href="http://postgresapp.com/documentation/install.html" target="_blank">http://postgresapp.com/documentation/install.html</a><div><div><div><br><div><div>On Oct 20, 2014, at 12:43 PM, Danqing Zhang <<a href="mailto:danqing0703@berkeley.edu" target="_blank">danqing0703@berkeley.edu</a>> wrote:</div><br><blockquote type="cite"><div dir="ltr"><div>Hi everyone</div><div><br></div><div>Thanks for the help!!</div><div><br></div>I also tried to install all things via <a href="http://boundlessgeo.com/solutions/opengeo-suite/" target="_blank">http://boundlessgeo.com/solutions/opengeo-suite/</a><br><div><br></div><div>I think my problem is that I tried to install PgRouting from too many sources, but I cannot get everything uninstalled completely. I previously even cannot get PostGIS working.</div><div><br></div><div>Can anyone give me some hints on how to <b>uninstall Postgres App completely</b> from Mac, for I think simply move to trash does not work, for it changed some environment variable I think. Many thanks for the help again!</div><div><br></div><div>Best, Danqing</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 20, 2014 at 9:30 AM, Yan Qian <span dir="ltr"><<a href="mailto:qianyanseu@gmail.com" target="_blank">qianyanseu@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Hi! I recently installed pgrouting via homebrew on OS X Yosemite (10.10) and everything worked. What I mean by 'via homebrew' is that all the dependencies are also installed from homebrew, including PostgreSQL and PostGIS.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">I suggest uninstalling the Postgres App that you already have on your system and try installing merely througn homebrew recipes.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Good luck!</div></div><div class="gmail_extra"><div><div><br><div class="gmail_quote">On Tue, Oct 21, 2014 at 12:26 AM, Thomas Cioppettini <span dir="ltr"><<a href="mailto:tom@tecrails.com" target="_blank">tom@tecrails.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Hey, I wrote the recipe for installing PgRouting through homebrew. Can you reply with a gist of the output you receive? I will see if I can resolve any issues after I am done with work this evening.<div><br></div><div>-Tom</div><div><br></div><div><div><div><div>On Oct 20, 2014, at 12:23 PM, Danqing Zhang <<a href="mailto:danqing0703@berkeley.edu" target="_blank">danqing0703@berkeley.edu</a>> wrote:</div><br></div><blockquote type="cite"><div><div dir="ltr">Hi everyone<div><br></div><div>I am a graduate student from Berkeley doing research on taxi trajectory, and I am in great need of PgRouting. However, I tried all methods and could not get PgRouting installed.</div><div><br></div><div>I installed PostgreSQL and PostGIS using Postgres App(<a href="http://postgresapp.com/" target="_blank">http://postgresapp.com/</a>), and tried the following ways to install PgRouting but all failed:</div><div><ul><li><span style="font-family:arial,sans-serif;font-size:13px">This website:</span><a href="http://www.google.com/url?q=http%3A%2F%2Fwww.kyngchaos.com%2Fsoftware%2Fpostgres&sa=D&sntz=1&usg=AFQjCNFq6h3OydMSJyBpwol-5vh93jT7Wg" style="font-family:arial,sans-serif;font-size:13px" target="_blank">http://www.kyngchaos.com/software/postgres</a><br></li><li>homebrew</li><li>macports</li></ul><div>Can anyone provide me with some useful links so that I can learn from them and install PgRouting on my Mac? Many thanks for the help!</div></div><div><br></div><div>Best, Danqing</div></div></div>
_______________________________________________<br>Pgrouting-users mailing list<br><a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a></blockquote></div><br></div></div><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br><br clear="all"><div><br></div></div></div><span><font color="#888888">-- <br><div dir="ltr"><font face="georgia, serif">yours, sincerely<br><b>Yan Qian</b></font><div><font face="georgia, serif">Dept. of GIS</font></div><div><font face="georgia, serif">Southeast University</font></div></div>
</font></span></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br></div>
_______________________________________________<br>Pgrouting-users mailing list<br><a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a></blockquote></div><br></div></div></div></div><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><font face="georgia, serif">yours, sincerely<br><b>Yan Qian</b></font><div><font face="georgia, serif">Dept. of GIS</font></div><div><font face="georgia, serif">Southeast University</font></div></div>
</div>