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.
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/
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:
In the documentation [http://docs.pgrouting.org/latest/en/pgRouting-installation.html](http://docs.pgrouting.org/latest/en/pgRouting-installation.html) its mentioned:
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/
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.
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.