<div dir="ltr"><div>Hi Riya,</div><div><br></div><div>For pgRouting you need a PostgreSQL database, which is named "routing" in the workshop and "mydatabase" in the Readme. But you can give it any name.</div><div>"psql" is the command of PostgreSQL that you execute in a Terminal window. It has multiple command line options, that you can see with "psql --help". For example you may need to provide a different username or a hostname, port number, etc.. In the workshop for example that the workshop username also exists as a database user.</div><div><br></div><div>You have two ways to execute SQL commands: either you first connect to the database and run your commands "inside" the database with SQL commands as in the workshop, or you pass the SQL command with the "-c" parameter.<br></div><div><br></div><div>After you create a database you need to load PostGIS and pgRouting as extension, because they are a PostgreSQL extension.</div><div>The software is smart enough to also install PostGIS, if you run "CREATE EXTENSION pgRouting CASCADE". It's basically the same as in the workshop.</div><div><br></div><div>I hope this helps,</div><div>Daniel<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 4 Feb 2021 at 22:57, Riya Singh <<a href="mailto:rsingh99mysteryfan@gmail.com">rsingh99mysteryfan@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr">Thank you for the help, I am going through the workshops and documentation of pgRouting. <div>The problems which I am facing is related to postgresql database setup.</div><div>In the readme file its mentioned:</div><div><pre style="box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:13.6px;margin-top:0px;margin-bottom:16px;padding:16px;overflow:auto;line-height:1.45;border-radius:6px;color:rgb(201,209,217)"><code style="box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:13.6px;padding:0px;margin:0px;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;border-radius:6px;word-break:normal;border:0px none;display:inline;overflow:visible;line-height:inherit"><b style="background-color:rgb(0,0,0)">createdb mydatabase
psql mydatabase -c "CREATE EXTENSION pgrouting CASCADE"</b></code></pre><pre style="box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:13.6px;margin-top:0px;margin-bottom:16px;padding:16px;overflow:auto;line-height:1.45;border-radius:6px;color:rgb(201,209,217)"><font style="font-size:13.6px" color="#000000">In the documentation </font><span style="font-size:13.6px;color:rgb(34,34,34)"><a href="http://docs.pgrouting.org/latest/en/pgRouting-installation.html" target="_blank">http://docs.pgrouting.org/latest/en/pgRouting-installation.html</a> its mentioned:</span></pre><pre style="box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:13.6px;margin-top:0px;margin-bottom:16px;padding:16px;overflow:auto;line-height:1.45;border-radius:6px"><pre style="box-sizing:border-box;line-height:1.42857;overflow:auto;clear:both;font-family:Menlo,Monaco,Consolas,"Courier New",monospace;font-size:13px;padding:9.5px;margin-top:0px;margin-bottom:0px;color:rgb(51,51,51);word-break:break-all;background-color:rgb(245,245,245);border:1px solid rgb(204,204,204);border-radius:4px">createdb routing
psql routing -c <span style="box-sizing:border-box;color:rgb(64,112,160)">'CREATE EXTENSION PostGIS'</span>
psql routing -c <span style="box-sizing:border-box;color:rgb(64,112,160)">'CREATE EXTENSION pgRouting'</span></pre></pre><pre style="box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:13.6px;margin-top:0px;margin-bottom:16px;padding:16px;overflow:auto;line-height:1.45;border-radius:6px;color:rgb(201,209,217)"><pre style="box-sizing:border-box;line-height:1.42857;overflow:auto;clear:both;font-family:Menlo,Monaco,Consolas,"Courier New",monospace;font-size:13px;padding:9.5px;margin-top:0px;margin-bottom:0px;color:rgb(51,51,51);word-break:break-all;background-color:rgb(245,245,245);border:1px solid rgb(204,204,204);border-radius:4px"><span style="box-sizing:border-box;color:rgb(0,112,32);font-weight:bold">CREATE</span> <span style="box-sizing:border-box">EXTENSION</span> <span style="box-sizing:border-box">postgis</span><span style="box-sizing:border-box">;</span>
<span style="box-sizing:border-box;color:rgb(0,112,32);font-weight:bold">CREATE</span> <span style="box-sizing:border-box">EXTENSION</span> <span style="box-sizing:border-box">pgrouting;</span></pre></pre></div></div><div class="gmail_quote"><div class="gmail_attr"> I am bit confused regarding this. Can you please expalin the steps in the order they should be exexcuted.</div><div class="gmail_attr"><br></div><div dir="ltr" class="gmail_attr">On Mon, Feb 1, 2021 at 7:25 AM Daniel Kastl <<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi Riya,</div><div><br></div><div>Nice to hear you are interested in pgRouting and GSoC!</div><div>It's hard to guess what you are confused about with the setup, so you had to explain ore in detail.</div><div>I would also recommend you to do the latest pgRouting workshop: <a href="https://workshop.pgrouting.org/" target="_blank">https://workshop.pgrouting.org/</a></div><div><br></div><div>Best regards,</div><div>Daniel</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 1 Feb 2021 at 02:01, Riya Singh <<a href="mailto:rsingh99mysteryfan@gmail.com" target="_blank">rsingh99mysteryfan@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi everyone,<div>
</div>
<div>I am Riya Singh a 3rd year computer science undergraduate and I would like to contribute to this project as a part of gsoc 2021. I have read the gsoc 2021 guidelines and also tried setting up the project locally on my system. I use Ubuntu 20.04 and I have installed postgresql and postgis and also compiled the project locally. But I am a bit confused about database setup. CAn someone please guide what instructions to run because there are multiple instructions mentioned in the wiki and the documentation page.</div></div>
_______________________________________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a></span><div><br></div><div><br></div><div><br></div></div></div></div></div>
_______________________________________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a><br>
</blockquote></div></div>
_______________________________________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a></span><div><br></div><div><br></div><div><br></div></div></div></div></div>