MySQL vs. PostgreSQL
MysqlRelatively young, appearing for the first 1994 years. It claims to be the most popular open source database. MySQL is the M in the lamp (for web development packages, including Linux, Apache, and Perl/php/python). Most
For the based service, I try to use PostgreSQL with PostGIS.You can download PostGIS from here.Http://postgis.net/sourceIt is recommended so need to download and compile yourself since there was many packages dependencies need to be Don E.Here is a
PostgreSQL & PostGIS Installation PostgreSQLAfter the Yum source is configured, the version with discoverable yum info postgresql PostgreSQL is 9.2.23, if you want to install the latest version, please refer to the following operation
https:
First, the geometry type in the PostGISPostGIS supports the "simple Features" type of all OGC specifications, and on this basis expands support for 3DZ, 3DM, and 4D coordinates.1. OGC WKB and WKT formatsThe OGC defines two formats for describing
Original: http://lovewinner.iteye.com/blog/1490915Installing PostgreSQL[Plain]View PlainCopy
sudo apt-get install postgresql-9.1 postgresql-contrib-9.1
Where postgresql-contrib-9.1 does not have to be installed, if you do not install
Install PostGIS in the source code of RedHat7
This article describes how to install and use PostGIS in RedHat7 environment.1. PostgreSQL1.1 install PostgreSQL in yum
This is relatively simple and can be directly installed using yum.
$ sudo yum
Install postgreSQL + postGIS in the production environment
The production environment is as follows:
Operating System:
CentOS release 5.5 (Final)
Installation required:
Postgresql address: http://www.postgresql.org/ftp/source/
PostgisAddress:
1 Server SetupUsing tomcat requires you to install Java first. Download the latest version of Java from the official Oracle website:Http://www.oracle.com/technetwork/java/javase/downloads/index.htmlAfter the installation has finished Java, you need
POSTGIS+GEOSERVER+OPENLAYERS3 based Open source solution is one of Webgis common development methods, and recently started to contact PostGIS and GeoServer because of project needs. Although the installation of PostGIS and GeoServer is a fool-type,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.