Re: [postgis-users] postgis-users Digest, Vol 111, Issue 4

[tom]

Ya voy de salida.
Sent from my BlackBerry® from Iusacell wireless device from Iusacell

-Original Message-
From: postgis-users-requ...@postgis.refractions.net
Sender: postgis-users-boun...@postgis.refractions.net
Date: Mon, 04 Jul 2011 12:00:02 
To: 
Reply-To: postgis-users@postgis.refractions.net
Subject: postgis-users Digest, Vol 111, Issue 4

Send postgis-users mailing list submissions to
postgis-users@postgis.refractions.net

To subscribe or unsubscribe via the World Wide Web, visit
http://postgis.refractions.net/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
postgis-users-requ...@postgis.refractions.net

You can reach the person managing the list at
postgis-users-ow...@postgis.refractions.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."


Today's Topics:

   1. Re: PostGIS 2.0 installation error (Mark Cave-Ayland)
   2. Re: PostGIS 2.0 installation error (Denis Rykov)
   3. Re: PG Routing (Maria Arias de Reyna)
   4. Re: PostGIS 2.0 installation error (Mark Cave-Ayland)
   5. Re: PostGIS 2.0 installation error (Denis Rykov)
   6. Re: PostGIS 2.0 installation error (Martin Spott)
   7. Re: PostGIS 2.0 installation error (Mark Cave-Ayland)
   8. Re: PG Routing (James David Smith)


--

Message: 1
Date: Sun, 03 Jul 2011 20:20:39 +0100
From: Mark Cave-Ayland 
Subject: Re: [postgis-users] PostGIS 2.0 installation error
To: PostGIS Users Discussion 
Message-ID: <4e10c107.5030...@siriusit.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

On 03/07/11 16:41, Denis Rykov wrote:

> |ERROR:  could not load library"/usr/lib/postgresql/9.0/lib/postgis-2.0.so  
> <http://postgis-2.0.so>": /usr/lib/postgresql/9.0/lib/postgis-2.0.so  
> <http://postgis-2.0.so>: undefined symbol: DirectFunctionCall3Coll
>
> |
>
> More detailed information at :
> http://gis.stackexchange.com/questions/11759/postgis-installation-error

That's a strange error - it almost implies that a PostgreSQL 9.0-only 
macro has been used somewhere in the source code. Which version of 
PostgreSQL are you building against?


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs


--

Message: 2
Date: Mon, 4 Jul 2011 05:12:33 +0700
From: Denis Rykov 
Subject: Re: [postgis-users] PostGIS 2.0 installation error
To: PostGIS Users Discussion 
Message-ID:

Content-Type: text/plain; charset="iso-8859-1"

I'm using "PostgreSQL 9.0.4 on i686-pc-linux-gnu, compiled by GCC
gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit"

On Mon, Jul 4, 2011 at 2:20 AM, Mark Cave-Ayland <
mark.cave-ayl...@siriusit.co.uk> wrote:

> On 03/07/11 16:41, Denis Rykov wrote:
>
>  |ERROR:  could not load library"/usr/lib/postgresql/9.**0/lib/
>> postgis-2.0.so  <http://postgis-2.0.so>": /usr/lib/postgresql/9.0/lib/po*
>> *stgis-2.0.so <http://postgis-2.0.so>  <http://postgis-2.0.so>: undefined
>> symbol: DirectFunctionCall3Coll
>>
>>
>> |
>>
>> More detailed information at :
>> http://gis.stackexchange.com/**questions/11759/postgis-**
>> installation-error<http://gis.stackexchange.com/questions/11759/postgis-installation-error>
>>
>
> That's a strange error - it almost implies that a PostgreSQL 9.0-only macro
> has been used somewhere in the source code. Which version of PostgreSQL are
> you building against?
>
>
> ATB,
>
> Mark.
>
> --
> Mark Cave-Ayland - Senior Technical Architect
> PostgreSQL - PostGIS
> Sirius Corporation plc - control through freedom
> http://www.siriusit.co.uk
> t: +44 870 608 0063
>
> Sirius Labs: http://www.siriusit.co.uk/labs
> __**_
> postgis-users mailing list
> postgis-users@postgis.**refractions.net
> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>
-- next part --
An HTML attachment was scrubbed...
URL: 
<http://postgis.refractions.net/pipermail/postgis-users/attachments/20110704/1435e227/attachment-0001.html>

--

Message: 3
Date: Mon, 4 Jul 2011 08:49:08 +0200
From: Maria Arias de Reyna 
Subject: Re: [postgis-users] PG Routing
To: PostGIS Users Discussion 
Message-ID: <201107040849.08612.mar...@emergya.es>
Content-Type: Text/Plain;  charset="iso-8859-1"

El Domingo 03 Julio 2011, James David Smith escribi?:

Re: [postgis-users] PG Routing

[James David Smith]

Dear Maria,

Thank you for your reply. I already have  PostgreSQL + PostGIS database
running which contains all of my information. The data is not a live system,
it is data from March 2010. I am doing some research on the data. I have
discovere that as I am using PostgreSQL 9.0 I cannot use pgRouting
unfortunately. So I now have two questions please?

1) If I uninstall PostgreSQL 9.0, and then install PostgreSQL 8.3 (so I can
use pgRouting), will my databases still be intact? Or will I lose all of my
tables and data?

2) Maybe an easier solution would be for me to create an OS GEO bootable USB
drive, and then do the work in Ubuntu? If I did this, will my existing
PostgreSQL databases be accesible through the Ubuntu version of PostgreSQL?
http://live.osgeo.org/en/quickstart/usb_quickstart.html

Thank you for your help

James



On 4 July 2011 07:49, Maria Arias de Reyna  wrote:

> El Domingo 03 Julio 2011, James David Smith escribió:
> > Dear all,
> >
> > I have a table of GPS points which are the locations of vehicles every
> > 15 seconds. Each journey that a car makes has an ID. For example a
> > taxi is on 'job 1' and has 50 points while it does this job, and then
> > another 50 or 60 when it is on 'job 2' etc. What I would like to do
> > however is investigate whether the car took the most effecient route
> > between the two points. To this end I think that I can use the
> > PGROUTING extension of PostGIS...?  Does this sound possible?
>
> You can calculate the shortest path with pgRouting and then compare it with
> the length of the linestring formed with this GPS points. Probably you will
> have a longer path with the GPS points (because the GPS is never exact) but
> if
> you add a percent of error to the shortest path calculated by pgRouting you
> will know if the vehicle did a good or a bad path.
>
> > I have
> > found the PGROUTING website, and download the ZIP file for Windows
> > installation, however I am not sure how to install it. Could somebody
> > please tell me how or provide a link to a good place to read about how
> > to install and use PGROUTING?
>
> Why are you using Windows (for any serious work)? There is a PPA for
> Ubuntu[1]
> which has a direct install while pgRouting binaries for Windows are old and
> strongly dependent of a postgresql version. And remember that you must
> install
> postgis first.
>
> Anyway, if you are thinking of having a real-time server with several
> vehicles
> sending positions every 15 seconds, forget Windows. It will be insane. If
> it
> is insane if you do it on a non-strongly-optimized database on Linux I
> don't
> want to know how hard it will be on Windows. Believe me, I have made a few
> of
> this real-time systems.
>
>
> [1]https://launchpad.net/~georepublic/+archive/pgrouting
> --
> María Arias de Reyna Domínguez
> Área de Operaciones
>
> Emergya Consultoría
> Tfno: +34 954 51 75 77 / +34 607 43 74 27
> Fax: +34 954 51 64 73
> www.emergya.es
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2.0 installation error

[Mark Cave-Ayland]

On 04/07/11 09:55, Martin Spott wrote:


Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server?


No  ;-)
Recent PostGIS SVN works nicely here, at least on a test-scenario I'm
running with PostgreSQL 9.1beta2,


I'm fairly sure that newer versions work with PostgreSQL 9.1 - perhaps 
you just need to "svn up" to a newer version (although there are still 
some outstanding regression errors here that need Paul's attention).


The output of configure should show you exactly which versions of 
various components have been detected if that helps at all?



ATB,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2.0 installation error

[Martin Spott]

Denis Rykov wrote:

> Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server?

No  ;-)
Recent PostGIS SVN works nicely here, at least on a test-scenario I'm
running with PostgreSQL 9.1beta2,

Martin.
-- 
 Unix _IS_ user friendly - it's just selective about who its friends are !
--
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2.0 installation error

[Denis Rykov]

In the beginning I tried to install 2.0 in PostgreSQL 9.1 and got an error
message, then I uninstalled it, installed 9.0 and got the same error
message.
Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server?

On Mon, Jul 4, 2011 at 3:17 PM, Mark Cave-Ayland <
mark.cave-ayl...@siriusit.co.uk> wrote:

> On 03/07/11 23:12, Denis Rykov wrote:
>
>  I'm using "PostgreSQL 9.0.4 on i686-pc-linux-gnu, compiled by GCC
>> gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit"
>>
>
> Hmmm. And no copies of 9.1 beta anywhere on that box either?
>
>
>
> ATB,
>
> Mark.
>
> --
> Mark Cave-Ayland - Senior Technical Architect
> PostgreSQL - PostGIS
> Sirius Corporation plc - control through freedom
> http://www.siriusit.co.uk
> t: +44 870 608 0063
>
> Sirius Labs: http://www.siriusit.co.uk/labs
> __**_
> postgis-users mailing list
> postgis-users@postgis.**refractions.net
> http://postgis.refractions.**net/mailman/listinfo/postgis-**users
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2.0 installation error

[Mark Cave-Ayland]

On 03/07/11 23:12, Denis Rykov wrote:


I'm using "PostgreSQL 9.0.4 on i686-pc-linux-gnu, compiled by GCC
gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit"


Hmmm. And no copies of 9.1 beta anywhere on that box either?


ATB,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users