[postgis-users] importing shape files nightmare!

Gérald Fenoy djayweb at djayux.net
Thu Sep 15 06:01:48 PDT 2005


Strange problem ipv6 connectivity seems wroking like a charme  ....

I would like to have trace from your download to see if you've  
downloaded the tarball with an ipv6 connection, is this possible ?

Have you got a correct route -inet6 ? (else you maybe need to use  
rtadvd)
Cause here I get :
tcp6       0      0 :::80                   :::*                     
LISTEN
so the access must work ...

Cordially.


Le 15 sept. 05 à 14:49, christomec a écrit :

> It looks like it's working now.
>
>
>> Not successful trying to ebuid postgis-1.0.4_p20050914.ebuild digest
>>
>> Response:
>>
>>
>>>>> Downloading
>>>>>
>> http://distfiles.gentoo.org/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz
>> --14:40:32--
>> http://distfiles.gentoo.org/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz
>>            => `/usr/portage/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz'
>> Resolving distfiles.gentoo.org... 156.56.247.195, 216.165.129.135,
>> 64.50.236.52
>> Connecting to distfiles.gentoo.org[156.56.247.195]:80... connected.
>> HTTP request sent, awaiting response... 404 Not Found
>> 14:41:06 ERROR 404: Not Found.
>>
>> No digest file available and download failed.
>>
>>
>>>>> Downloading
>>>>>
>> http://distro.ibiblio.org/pub/Linux/distributions/gentoo/distfiles/ 
>> postgis-cvs-1.0.4_p20050914.tar.gz
>> --14:41:06--
>> http://distro.ibiblio.org/pub/Linux/distributions/gentoo/distfiles/ 
>> postgis-cvs-1.0.4_p20050914.tar.gz
>>            => `/usr/portage/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz'
>> Resolving distro.ibiblio.org... 152.2.210.109
>> Connecting to distro.ibiblio.org[152.2.210.109]:80... connected.
>> HTTP request sent, awaiting response... 404 Not Found
>> 14:41:41 ERROR 404: Not Found.
>>
>> No digest file available and download failed.
>>
>>
>>>>> Downloading
>>>>>
>> http://www.01map.net/gentoo/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz
>> --14:41:41--
>> http://www.01map.net/gentoo/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz
>>            => `/usr/portage/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz'
>> Resolving www.01map.net... 2001:770:139:0:211:2fff:feba:3a94
>> Connecting to www.01map.net[2001:770:139:0:211:2fff:feba:3a94]:80...
>> failed: Network is unreachable.
>> Retrying.
>>
>> --14:42:16--
>> http://www.01map.net/gentoo/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz
>>   (try: 2) => `/usr/portage/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz'
>> Connecting to www.01map.net[2001:770:139:0:211:2fff:feba:3a94]:80...
>> failed: Network is unreachable.
>> Retrying.
>>
>> --14:42:18--
>> http://www.01map.net/gentoo/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz
>>   (try: 3) => `/usr/portage/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz'
>> Connecting to www.01map.net[2001:770:139:0:211:2fff:feba:3a94]:80...
>> failed: Network is unreachable.
>> Retrying.
>>
>> --14:42:21--
>> http://www.01map.net/gentoo/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz
>>   (try: 4) => `/usr/portage/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz'
>> Connecting to www.01map.net[2001:770:139:0:211:2fff:feba:3a94]:80...
>> failed: Network is unreachable.
>> Retrying.
>>
>> --14:42:25--
>> http://www.01map.net/gentoo/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz
>>   (try: 5) => `/usr/portage/distfiles/postgis- 
>> cvs-1.0.4_p20050914.tar.gz'
>> Connecting to www.01map.net[2001:770:139:0:211:2fff:feba:3a94]:80...
>> failed: Network is unreachable.
>> Giving up.
>>
>> No digest file available and download failed.
>>
>> !!! Couldn't download postgis-cvs-1.0.4_p20050914.tar.gz. Aborting.
>>
>>
>>
>>
>>> The correct link is
>>>
>>> http://www.postgis.fr/gentoo/dev-db/postgis/ 
>>> postgis-1.0.4_p20050914.ebuild
>>>
>>> without space between postgis and postgis-1.0.4_p20050914.ebuild
>>>
>>>
>>> Gérald Fenoy wrote:
>>>
>>>
>>>> HI Christo,
>>>> argh realy sorry there is one dot before underscore in the link.
>>>> The link is then http://www.postgis.fr/gentoo/dev-db/postgis/
>>>> postgis-1.0.4_p20050914.ebuild (you could also use the http://www.
>>>> 01map.net/gentoo/dev-db/postgis).
>>>> A new will be posted in my blog today
>>>> (http://www.postgis.fr/?q=blog/1).
>>>>
>>>> Le 15 sept. 05 à 14:23, christomec a écrit :
>>>>
>>>>
>>>>> Hi GXrald,
>>>>>
>>>>> Trying to download
>>>>>
>>>>>
>>>>>> http://www.postgis.fr/gentoo/dev-db/postgis/
>>>>>> postgis-1.0.4._p20050914.ebuild
>>>>>>
>>>>>
>>>>> I get : "Page non trouvée"
>>>>>
>>>>> Trying to browse www.postgis.fr/gentoo/dev-db/postgis/ I get: "You
>>>>> don't
>>>>> have permission to access /gentoo/dev-db/postgis/ on this server."
>>>>>
>>>>> Thank you,
>>>>> Christo
>>>>>
>>>>>
>>>>>
>>>>>> Hi,
>>>>>> sorry for redundency but ... you could find the
>>>>>> postgis-1.0.4_p20050914.ebuild here : http://www.postgis.fr/ 
>>>>>> gentoo/
>>>>>> dev-db/postgis/postgis-1.0.4._p20050914.ebuild .
>>>>>>
>>>>>> Feel free to send any comments here.
>>>>>>
>>>>>> Cordially.
>>>>>>
>>>>>> Le 15 sept. 05 à 09:12, christomec a écrit :
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Thank you,
>>>>>>>
>>>>>>> I currently have postgis-1.0.1_p20050727-r1 emerged on my gentoo
>>>>>>> box, why
>>>>>>> does the select postgis_full_version() return  
>>>>>>> POSTGIS="1.1.0CVS"?
>>>>>>>
>>>>>>> And where can I find a postgis-1.0.4 ebuild?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>> Version 1.0.4 of PostGIS contains a fix for your case.
>>>>>>>> --strk;
>>>>>>>>
>>>>>>>> On Wed, Sep 14, 2005 at 11:38:54PM +0200, christomec wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> I have two machines, suse and gentoo
>>>>>>>>>
>>>>>>>>> suse:
>>>>>>>>>
>>>>>>>>> select version();
>>>>>>>>> PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc  
>>>>>>>>> (GCC)
>>>>>>>>> 3.3.5
>>>>>>>>> 20050117 (prerelease) (SUSE Linux)
>>>>>>>>>
>>>>>>>>> select postgis_full_version();
>>>>>>>>> POSTGIS="1.0.3" PROJ="Rel. 4.4.8, 3 May 2004" USE_STATS
>>>>>>>>> DBPROC="0.3.0"
>>>>>>>>> RELPROC="0.3.0"
>>>>>>>>>
>>>>>>>>> gentoo:
>>>>>>>>>
>>>>>>>>> select version();
>>>>>>>>> PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC
>>>>>>>>> i686-pc-linux-gnu-gcc (GCC) 3.3.6 (Gentoo 3.3.6,  
>>>>>>>>> ssp-3.3.6-1.0,
>>>>>>>>> pie-8.7.8)
>>>>>>>>>
>>>>>>>>> select postgis_full_version();
>>>>>>>>> POSTGIS="1.1.0CVS" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004"
>>>>>>>>> USE_STATS
>>>>>>>>> DBPROC="0.3.1" RELPROC="0.3.1"
>>>>>>>>>
>>>>>>>>> running:
>>>>>>>>>
>>>>>>>>> shp2pgsql -c streets.shp streets | psql -d dbname
>>>>>>>>>
>>>>>>>>> suse, no problem!
>>>>>>>>>
>>>>>>>>> gentoo: ERROR:  unterminated quoted string at or near
>>>>>>>>> "'010500000001000000010...
>>>>>>>>>
>>>>>>>>> trying:
>>>>>>>>>
>>>>>>>>> shp2pgsql -D streets.shp streets dbname > streets.sql
>>>>>>>>>
>>>>>>>>> suse, no problem!
>>>>>>>>>
>>>>>>>>> gentoo:
>>>>>>>>> Shapefile type: Arc
>>>>>>>>> Postgis type: MULTILINESTRING[2]
>>>>>>>>> Segmentation fault
>>>>>>>>>
>>>>>>>>> finally:
>>>>>>>>>
>>>>>>>>> Trying to import streets.sql generated on the suse machine  
>>>>>>>>> into
>>>>>>>>> postgresql
>>>>>>>>> running on the gentoo machine also fails:
>>>>>>>>>
>>>>>>>>> psql:streets.sql:1350: invalid command \N
>>>>>>>>>
>>>>>>>>> What is it with the gentoo installation? What should I  
>>>>>>>>> upgrade or
>>>>>>>>> downgrade to remedy this problems I'm having?
>>>>>>>>>
>>>>>>>>> Please help, it is really important that I get this done  
>>>>>>>>> and I'm
>>>>>>>>> really
>>>>>>>>> stuck trying to solve it.
>>>>>>>>>
>>>>>>>>> Kind Regards,
>>>>>>>>> Christo Du Preez
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> postgis-users mailing list
>>>>>>>>> postgis-users at postgis.refractions.net
>>>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> postgis-users mailing list
>>>>>>>> postgis-users at postgis.refractions.net
>>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> postgis-users mailing list
>>>>>>> postgis-users at postgis.refractions.net
>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> postgis-users mailing list
>>>>>> postgis-users at postgis.refractions.net
>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users at postgis.refractions.net
>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at postgis.refractions.net
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> ____________________________________________________________________ 
>>> _______
>>> Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo!
>>> Messenger
>>> Téléchargez cette version sur http://fr.messenger.yahoo.com
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>>
>>>
>>>
>>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>> !DSPAM:43296d81243671320783848!
>>
>>
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>




More information about the postgis-users mailing list