[pgrouting-users] Syntax error in sampledata_notopo.sql

[Daniel Kastl]

Hi Maruf,

In your first email you wrote, that you created a database first. But the
database creation is actually part of SQL dump file already.
You can also just login to some other database and then run "\i
path/to/sampledata_notopo.sql"

Inside this file it creates the database like this:
CREATE DATABASE "pgrouting-workshop" WITH TEMPLATE = template_routing
ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';

So it is looking for a "template_routing" template database, that was
mentioned in a previous chapter.
The errors you posted you need to debug from top. So first it complains
about already existing database and second about missing "geometry" things.
When using the template database it should work.

Daniel




On Sun, Mar 10, 2013 at 12:22 AM, maruf rahman <maruf.csdu at gmail.com> wrote:

> Here is the original sampledata_notopo.sql file.
>
> https://docs.google.com/file/d/0B3djwV2dbCYZVV9QVjg3TngzUzg/edit?usp=sharing
>
>
> On Sat, Mar 9, 2013 at 9:18 PM, maruf rahman <maruf.csdu at gmail.com> wrote:
>
>> Hi
>> The problem still occurs. Here is the output<http://paste.ubuntu.com/5599146/>
>> .
>> Previously i replaced all '\N', so it wasn't in error list. Now I have
>> run the command in original file.
>>
>> Thanks
>> Maruf
>>
>>
>>
>> On Sat, Mar 9, 2013 at 8:46 PM, Daniel Kastl <daniel at georepublic.de>wrote:
>>
>>> Hi Maruf,
>>>
>>> Could be that this version of the workshop is outdated as it's the one
>>> from FOSS4G 2010.
>>> Can you try the workshop FOSS4G 2011 instead?
>>> The most up-to-date content is always the online version:
>>> http://workshop.pgrouting.org/
>>>
>>> Daniel
>>>
>>>
>>> On Sat, Mar 9, 2013 at 11:28 PM, maruf rahman <maruf.csdu at gmail.com>wrote:
>>>
>>>> Hi
>>>>
>>>> I am trying to install and use pgrouting using the attached document.
>>>> Currently I am in step 5.1(Load network data). It says to create a database
>>>> and load data in it using the following two commands.
>>>>
>>>> *createdb -U postgres pgrouting-workshop
>>>>
>>>> psql -U postgres -d pgrouting-workshop \
>>>> -f ~/Desktop/pgrouting-workshop/data/sampledata_notopo.sql*
>>>>
>>>> The first one goes well. When I execute the second command I get some
>>>> errors. Please check here <http://paste.ubuntu.com/5598943/>.
>>>> Here<https://docs.google.com/file/d/0B3djwV2dbCYZMk1kZS1mQmdYVTg/edit?usp=sharing>is the sampledata_notopo.sql file.
>>>>
>>>> How can I solve this problem?
>>>>
>>>> Thanks
>>>> Maruf
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Pgrouting-users mailing list
>>>> Pgrouting-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>>
>>>>
>>>
>>>
>>> --
>>> Georepublic UG & Georepublic Japan
>>> eMail: daniel.kastl at georepublic.de
>>> Web: http://georepublic.de
>>>
>>> _______________________________________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>
>>>
>>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20130310/3cbe27ae/attachment-0001.html>