I have noticed that recently Amazon Web Services offer PostgreSQL as a
cloud database solution. I don't have much experience with this sort
of thing, but I'm wondering whether to look into it as 1) it seems
very reasonably priced and I'm sure it will be quicker than running it
on my local machine 2) It will also ensure that regular back-ups are
automatically taken 3) I would like to learn PHP soon and presume I
would be able to easily interact with the database.
In summary, I'm considering giving it a go. Two things that I am wary
of however, were that I need my PostgreSQL database to have GIS
(PostGIS) and routing (pgRouting) capabilities. It seems from the
guide here that PostGIS will be relatively easy to install by simply
following the instructions:
But I am less sure about pgRouting. There aren't any guides that I can
find. Is someone with more expertise than me able to comment on how I
might go about this please? If it is even possible?
I have noticed that recently Amazon Web Services offer PostgreSQL as a
cloud database solution. I don’t have much experience with this sort
of thing, but I’m wondering whether to look into it as 1) it seems
very reasonably priced and I’m sure it will be quicker than running it
on my local machine 2) It will also ensure that regular back-ups are
automatically taken 3) I would like to learn PHP soon and presume I
would be able to easily interact with the database.
In summary, I’m considering giving it a go. Two things that I am wary
of however, were that I need my PostgreSQL database to have GIS
(PostGIS) and routing (pgRouting) capabilities. It seems from the
guide here that PostGIS will be relatively easy to install by simply
following the instructions:
But I am less sure about pgRouting. There aren’t any guides that I can
find. Is someone with more expertise than me able to comment on how I
might go about this please? If it is even possible?
I have noticed that recently Amazon Web Services offer PostgreSQL as a
cloud database solution. I don’t have much experience with this sort
of thing, but I’m wondering whether to look into it as 1) it seems
very reasonably priced and I’m sure it will be quicker than running it
on my local machine 2) It will also ensure that regular back-ups are
automatically taken 3) I would like to learn PHP soon and presume I
would be able to easily interact with the database.
In summary, I’m considering giving it a go. Two things that I am wary
of however, were that I need my PostgreSQL database to have GIS
(PostGIS) and routing (pgRouting) capabilities. It seems from the
guide here that PostGIS will be relatively easy to install by simply
following the instructions:
But I am less sure about pgRouting. There aren’t any guides that I can
find. Is someone with more expertise than me able to comment on how I
might go about this please? If it is even possible?
Any use, dissemination, distribution, posting on Internet bulletin boards, disclosure or copying of this e-mail or any information contained herein by or to anyone other than the intended recipient(s) is strictly prohibited. Use of this content for any other purpose is a violation of International Copyright Laws.
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that's beyond me, I work in Windows
at the moment and have only limited experience of using linux.
'Opening a terminal window' was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I'd first need to
somehow be able to do that from within AWS - which I don't. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn't be compatible...?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how.....!
James
On 23 February 2012 22:59, Max Weninger <max.weninger@gmail.com> wrote:
Hi
On Thu, 23 Feb 2012 22:45:07 +0000
James David Smith <james.david.smith@gmail.com> wrote:
But I am less sure about pgRouting. There aren't any guides that I can
find.
I’m not that experienced with AWS, altought i’ve tried a few times.
The “vanilla” installation for PostgreSQL 9.0 that it provides can be “auto installed”, but you can start up a machine, connect to it via ssh (secure shell) and from there download and install all packages that you may want, just like a regular machine.
But that is true, you’ll need pgsql 9.4, there is no pgRouting for 9.x (yet).
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that’s beyond me, I work in Windows
at the moment and have only limited experience of using linux.
‘Opening a terminal window’ was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I’d first need to
somehow be able to do that from within AWS - which I don’t. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn’t be compatible…?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how…!
Sorry - didnt noticed that this is postgres 9
I think "official" support for postgres 9 is coming in
the next pgrouting release but the "experts" here should give
an answer to that.
Regards
max
On Thu, 23 Feb 2012 23:14:13 +0000
James David Smith <james.david.smith@gmail.com> wrote:
Hi all,
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that's beyond me, I work in Windows
at the moment and have only limited experience of using linux.
'Opening a terminal window' was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I'd first need to
somehow be able to do that from within AWS - which I don't. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn't be compatible...?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how.....!
James
On 23 February 2012 22:59, Max Weninger <max.weninger@gmail.com>
wrote:
> Hi
>
> On Thu, 23 Feb 2012 22:45:07 +0000
> James David Smith <james.david.smith@gmail.com> wrote:
>
>> But I am less sure about pgRouting. There aren't any guides that I
>> can find.
>
> Try this one
> http://workshop.pgrouting.org/chapters/installation.html
>
> Regards
>
> max
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/pgrouting-users
Yes, I think pgRouting running on Postgres 9 is a requirement. Well I don't have Postgres 9 installed here, and have not tried it, I am also not away of any issues in this regard.
If you are trying to install from binary packages, there may be an issue that the package builders have not build packages for it. If I can find some time to create a Virtual Machine I'll try to install postgres 9 and pgrouting and report back, but don't hold your breath, as I have been crazy busy lately.
Regarding the next release, we know we need one, but having lost our developer and release manager, we are in the process of trying to get some other people involved and this takes time. If you have time and want to volunteer I'm sure we can come up with taks suited to your skills.
Thanks,
-Steve
On 2/23/2012 6:33 PM, Max Weninger wrote:
Hi
Sorry - didnt noticed that this is postgres 9
I think "official" support for postgres 9 is coming in
the next pgrouting release but the "experts" here should give
an answer to that.
Regards
max
On Thu, 23 Feb 2012 23:14:13 +0000
James David Smith<james.david.smith@gmail.com> wrote:
Hi all,
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that's beyond me, I work in Windows
at the moment and have only limited experience of using linux.
'Opening a terminal window' was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I'd first need to
somehow be able to do that from within AWS - which I don't. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn't be compatible...?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how.....!
James
On 23 February 2012 22:59, Max Weninger<max.weninger@gmail.com>
wrote:
Hi
On Thu, 23 Feb 2012 22:45:07 +0000
James David Smith<james.david.smith@gmail.com> wrote:
But I am less sure about pgRouting. There aren't any guides that I
can find.
pgRouting works with PostgreSQL 9.x
I compiled it on Open Suse. And I built packages for Ubuntu 11.10 64bit because I needed them.
I didn’t upload to Launchpad repository yet, because I wanted to test more first and then had no time.
Packages are here for now: http://build.eq8.georepublic.net/build/oneiric-amd64_result/
Usually issues are with boost paths, CGAL and libgmp … not with PostgreSQL.
Some compile issues and how to solve them are already mentioned in tickets.
If packages work on AWS or not I don’t know though.
Reports about success and failure are welcome.
Yes, I think pgRouting running on Postgres 9 is a requirement. Well I don’t have Postgres 9 installed here, and have not tried it, I am also not away of any issues in this regard.
If you are trying to install from binary packages, there may be an issue that the package builders have not build packages for it. If I can find some time to create a Virtual Machine I’ll try to install postgres 9 and pgrouting and report back, but don’t hold your breath, as I have been crazy busy lately.
Regarding the next release, we know we need one, but having lost our developer and release manager, we are in the process of trying to get some other people involved and this takes time. If you have time and want to volunteer I’m sure we can come up with taks suited to your skills.
Thanks,
-Steve
On 2/23/2012 6:33 PM, Max Weninger wrote:
Hi
Sorry - didnt noticed that this is postgres 9
I think “official” support for postgres 9 is coming in
the next pgrouting release but the “experts” here should give
an answer to that.
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that’s beyond me, I work in Windows
at the moment and have only limited experience of using linux.
‘Opening a terminal window’ was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I’d first need to
somehow be able to do that from within AWS - which I don’t. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn’t be compatible…?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how…!
AWS allows you to setup and configure several different distributions of Linux that will support Postgres9.x/PostGIS and pgRouting.
When you create a new Linux instance you get access via SSH, but there are articles on the internet describing how to install GUI tools so you can log in via remote desktop/etc.
pgRouting works with PostgreSQL 9.x
I compiled it on Open Suse. And I built packages for Ubuntu 11.10 64bit because I needed them.
I didn’t upload to Launchpad repository yet, because I wanted to test more first and then had no time.
Packages are here for now: http://build.eq8.georepublic.net/build/oneiric-amd64_result/
Usually issues are with boost paths, CGAL and libgmp … not with PostgreSQL.
Some compile issues and how to solve them are already mentioned in tickets.
If packages work on AWS or not I don’t know though.
Reports about success and failure are welcome.
Yes, I think pgRouting running on Postgres 9 is a requirement. Well I don’t have Postgres 9 installed here, and have not tried it, I am also not away of any issues in this regard.
If you are trying to install from binary packages, there may be an issue that the package builders have not build packages for it. If I can find some time to create a Virtual Machine I’ll try to install postgres 9 and pgrouting and report back, but don’t hold your breath, as I have been crazy busy lately.
Regarding the next release, we know we need one, but having lost our developer and release manager, we are in the process of trying to get some other people involved and this takes time. If you have time and want to volunteer I’m sure we can come up with taks suited to your skills.
Thanks,
-Steve
On 2/23/2012 6:33 PM, Max Weninger wrote:
Hi
Sorry - didnt noticed that this is postgres 9
I think “official” support for postgres 9 is coming in
the next pgrouting release but the “experts” here should give
an answer to that.
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that’s beyond me, I work in Windows
at the moment and have only limited experience of using linux.
‘Opening a terminal window’ was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I’d first need to
somehow be able to do that from within AWS - which I don’t. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn’t be compatible…?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how…!
AWS allows you to setup and configure several different distributions of Linux that will support Postgres9.x/PostGIS and pgRouting.
When you create a new Linux instance you get access via SSH, but there are articles on the internet describing how to install GUI tools so you can log in via remote desktop/etc.
Ah, what was written before is all about the regular AWS?
I thought there is something new when I read …
I have noticed that recently Amazon Web Services offer PostgreSQL as a
cloud database solution.
If you can setup any Linux OS you like there is no reason why pgRouting shouldn’t be installable, right?
pgRouting works with PostgreSQL 9.x
I compiled it on Open Suse. And I built packages for Ubuntu 11.10 64bit because I needed them.
I didn’t upload to Launchpad repository yet, because I wanted to test more first and then had no time.
Packages are here for now: http://build.eq8.georepublic.net/build/oneiric-amd64_result/
Usually issues are with boost paths, CGAL and libgmp … not with PostgreSQL.
Some compile issues and how to solve them are already mentioned in tickets.
If packages work on AWS or not I don’t know though.
Reports about success and failure are welcome.
Yes, I think pgRouting running on Postgres 9 is a requirement. Well I don’t have Postgres 9 installed here, and have not tried it, I am also not away of any issues in this regard.
If you are trying to install from binary packages, there may be an issue that the package builders have not build packages for it. If I can find some time to create a Virtual Machine I’ll try to install postgres 9 and pgrouting and report back, but don’t hold your breath, as I have been crazy busy lately.
Regarding the next release, we know we need one, but having lost our developer and release manager, we are in the process of trying to get some other people involved and this takes time. If you have time and want to volunteer I’m sure we can come up with taks suited to your skills.
Thanks,
-Steve
On 2/23/2012 6:33 PM, Max Weninger wrote:
Hi
Sorry - didnt noticed that this is postgres 9
I think “official” support for postgres 9 is coming in
the next pgrouting release but the “experts” here should give
an answer to that.
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that’s beyond me, I work in Windows
at the moment and have only limited experience of using linux.
‘Opening a terminal window’ was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I’d first need to
somehow be able to do that from within AWS - which I don’t. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn’t be compatible…?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how…!
AWS allows you to setup and configure several different distributions of Linux that will support Postgres9.x/PostGIS and pgRouting.
When you create a new Linux instance you get access via SSH, but there are articles on the internet describing how to install GUI tools so you can log in via remote desktop/etc.
Ah, what was written before is all about the regular AWS?
I thought there is something new when I read …
I have noticed that recently Amazon Web Services offer PostgreSQL as a
cloud database solution.
If you can setup any Linux OS you like there is no reason why pgRouting shouldn’t be installable, right?
pgRouting works with PostgreSQL 9.x
I compiled it on Open Suse. And I built packages for Ubuntu 11.10 64bit because I needed them.
I didn’t upload to Launchpad repository yet, because I wanted to test more first and then had no time.
Packages are here for now: http://build.eq8.georepublic.net/build/oneiric-amd64_result/
Usually issues are with boost paths, CGAL and libgmp … not with PostgreSQL.
Some compile issues and how to solve them are already mentioned in tickets.
If packages work on AWS or not I don’t know though.
Reports about success and failure are welcome.
Yes, I think pgRouting running on Postgres 9 is a requirement. Well I don’t have Postgres 9 installed here, and have not tried it, I am also not away of any issues in this regard.
If you are trying to install from binary packages, there may be an issue that the package builders have not build packages for it. If I can find some time to create a Virtual Machine I’ll try to install postgres 9 and pgrouting and report back, but don’t hold your breath, as I have been crazy busy lately.
Regarding the next release, we know we need one, but having lost our developer and release manager, we are in the process of trying to get some other people involved and this takes time. If you have time and want to volunteer I’m sure we can come up with taks suited to your skills.
Thanks,
-Steve
On 2/23/2012 6:33 PM, Max Weninger wrote:
Hi
Sorry - didnt noticed that this is postgres 9
I think “official” support for postgres 9 is coming in
the next pgrouting release but the “experts” here should give
an answer to that.
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that’s beyond me, I work in Windows
at the moment and have only limited experience of using linux.
‘Opening a terminal window’ was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I’d first need to
somehow be able to do that from within AWS - which I don’t. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn’t be compatible…?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how…!
AWS allows you to setup and configure several different distributions of Linux that will support Postgres9.x/PostGIS and pgRouting.
When you create a new Linux instance you get access via SSH, but there are articles on the internet describing how to install GUI tools so you can log in via remote desktop/etc.
Ah, what was written before is all about the regular AWS?
I thought there is something new when I read …
I have noticed that recently Amazon Web Services offer PostgreSQL as a
cloud database solution.
If you can setup any Linux OS you like there is no reason why pgRouting shouldn’t be installable, right?
pgRouting works with PostgreSQL 9.x
I compiled it on Open Suse. And I built packages for Ubuntu 11.10 64bit because I needed them.
I didn’t upload to Launchpad repository yet, because I wanted to test more first and then had no time.
Packages are here for now: http://build.eq8.georepublic.net/build/oneiric-amd64_result/
Usually issues are with boost paths, CGAL and libgmp … not with PostgreSQL.
Some compile issues and how to solve them are already mentioned in tickets.
If packages work on AWS or not I don’t know though.
Reports about success and failure are welcome.
Yes, I think pgRouting running on Postgres 9 is a requirement. Well I don’t have Postgres 9 installed here, and have not tried it, I am also not away of any issues in this regard.
If you are trying to install from binary packages, there may be an issue that the package builders have not build packages for it. If I can find some time to create a Virtual Machine I’ll try to install postgres 9 and pgrouting and report back, but don’t hold your breath, as I have been crazy busy lately.
Regarding the next release, we know we need one, but having lost our developer and release manager, we are in the process of trying to get some other people involved and this takes time. If you have time and want to volunteer I’m sure we can come up with taks suited to your skills.
Thanks,
-Steve
On 2/23/2012 6:33 PM, Max Weninger wrote:
Hi
Sorry - didnt noticed that this is postgres 9
I think “official” support for postgres 9 is coming in
the next pgrouting release but the “experts” here should give
an answer to that.
Thanks for the replies, and especially to Max for the link to the
installation guide. Unfortunately that’s beyond me, I work in Windows
at the moment and have only limited experience of using linux.
‘Opening a terminal window’ was about as far as I got before not
really knowing what to do! I guess that the terminal window would need
running from within the AWS service too, so even if I knew how to open
a terminal window and start entering those commands I’d first need to
somehow be able to do that from within AWS - which I don’t. Also I
note that the AWS PostgreSQL cloud service is for PostgreSQL 9.0 and
9.1, whereas the instructions you gave Max seem to relate to
PostgreSQL 8.4 - and hence wouldn’t be compatible…?
Sorry for being a bit of a newbie - still learning! This would all be
pretty cool if I only had the know-how…!