[postgis-users] importing shape files nightmare!
christomec
christo at mecola.com
Thu Sep 15 05:49:06 PDT 2005
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!
>
>
>
More information about the postgis-users
mailing list