[Talk-in] [OSM-Server] Set the Spatial Reference Identifier (SRID)...Problem

[PARVEEN ARORA]

On Tue, Jun 15, 2010 at 4:10 PM, Pradeep B V <pradeepbv at gmail.com> wrote:

> Going by the error message it looks the the file 900913.sql is not found in
> the path specified.
>
> Can you check if the file exists?
>

 > Sir i have solved this problem now....Thanx for your immediate reply.

> But sir now ihave caught n the next problem  which is:
>  Load planet into the database with osm2pgsql

Your planet file will have a different date. Use an extract file if your
interest is limited to a smaller portion of the planet. This operation will
take 30 hours or longer. It is very I/O intensive and you can speed it up
with very fast disks.
cd ~/bin/osm2pgsql
./osm2pgsql -S default.style --slim -d gis -C 2048
~/planet/planet-100217.osm.bz2


  This is giving the error:

    >osm2pgsql SVN version 0.69-21719

    >Connection to database failed: FATAL:  role "oops" does not exist

and when i do it into postgress at hostname:$
    it asked for password of postgress but i have not given any password
while creating user..


> On Tue, Jun 15, 2010 at 3:49 PM, PARVEEN ARORA <parveenaroraosm at gmail.com>wrote:
>
>> Sir
>>   I am installing the openstreetmap server on ubuntu 10.04 Server edition.
>>
>> So i am following the tutorial from:
>> http://weait.com/content/build-your-own-openstreetmap-server#comment-1680
>>
>>
>>  I have run all steps successfully except the following one,which in turns
>> has stopped me in installing osm server,
>>  But the problem in the following step is coming again and again.
>>
>> Set the Spatial Reference Identifier (SRID) on the new database.
>> *#psql -f ~/bin/osm2pgsql/900913.sql -d gis*
>>
>> This command is giving the following problem:
>> */var/lib/postgresql/bin/osm2pgsql/900913.sql: No such file or directory
>>
>> *Instead this should give the
>>
>> INSERT 0 1
>>
>>
>> what is the reason of it..only this step is not working..
>> Help me as soon as possible...
>>
>> Thank's in advance.
>>
>>
>> _______________________________________________
>> Talk-in mailing list
>> Talk-in at openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/talk-in
>>
>>
>
> _______________________________________________
> Talk-in mailing list
> Talk-in at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-in
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-in/attachments/20100615/824efa91/attachment.html>