[postgis-users] importing shape files nightmare!

christomec christo at mecola.com
Thu Sep 15 06:29:27 PDT 2005


I'm sorry, unfortunetaly I don't have a trace.

> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>
>> _______________________________________________
>> 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:43297139260661094915365!
>
>
>




More information about the postgis-users mailing list