[pgrouting-dev] Want to contribute to pgrouting

[Daniel Kastl]

Hi Riya,

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.
"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.

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.

After you create a database you need to load PostGIS and pgRouting as
extension, because they are a PostgreSQL extension.
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.

I hope this helps,
Daniel

On Thu, 4 Feb 2021 at 22:57, Riya Singh <rsingh99mysteryfan at gmail.com>
wrote:

> Thank you for the help, I am going through the workshops and documentation
> of pgRouting.
> The problems which I am facing is related to postgresql database setup.
> In the readme file its mentioned:
>
> *createdb mydatabase
> psql mydatabase -c "CREATE EXTENSION pgrouting CASCADE"*
>
> In the documentation http://docs.pgrouting.org/latest/en/pgRouting-installation.html its mentioned:
>
> createdb routing
> psql routing -c 'CREATE EXTENSION PostGIS'
> psql routing -c 'CREATE EXTENSION pgRouting'
>
> CREATE EXTENSION postgis;CREATE EXTENSION pgrouting;
>
>     I am bit confused regarding this. Can you please expalin the steps in
> the order they should be exexcuted.
>
> On Mon, Feb 1, 2021 at 7:25 AM Daniel Kastl <daniel at georepublic.de> wrote:
>
>> Hi Riya,
>>
>> Nice to hear you are interested in pgRouting and GSoC!
>> It's hard to guess what you are confused about with the setup, so you had
>> to explain ore in detail.
>> I would also recommend you to do the latest pgRouting workshop:
>> https://workshop.pgrouting.org/
>>
>> Best regards,
>> Daniel
>>
>>
>> On Mon, 1 Feb 2021 at 02:01, Riya Singh <rsingh99mysteryfan at gmail.com>
>> wrote:
>>
>>> Hi everyone,
>>> 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.
>>> _______________________________________________
>>> pgrouting-dev mailing list
>>> pgrouting-dev at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>>
>>
>>
>> --
>> Georepublic UG & Georepublic Japan
>> eMail: daniel.kastl at georepublic.de
>> Web: https://georepublic.info
>>
>>
>>
>> _______________________________________________
>> pgrouting-dev mailing list
>> pgrouting-dev at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: https://georepublic.info
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20210204/520291f5/attachment.html>