sudo apt-get install ubuntu-desktop
sudo apt-get install rar unrar scim
sudo add-apt-repository ppa:ferramroberto/java
sudo apt-get update
sudo apt-get install sun-java6-bin sun-java6-fonts sun-java6-jdk sun-java6-plugin sun-java6-jre
sudo update-alternatives --config java
sudo apt-get install postgresql-9.1 postgis postgresql-9.1-postgis
postgresql-server-dev-9.1 postgresql-contrib-9.1 qgis qgis-common
pgadmin3 gdal-bin binutils
sudo -u postgres psql postgres
alter user postgres with encrypted password 'new password';
\q
sudo vi /etc/environment
JAVA_HOME="/usr/lib/jvm/java-6-sun"
CATALINA_HOME="/home/yinghua/tools/apache-tomcat-6.0.35"
PATH="$JAVA_HOME/bin:$CATALINA_HOME/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/lib/postgresql/9.1/bin"
:wq
source /etc/environment
sudo -u postgres createdb -E UTF8 template_postgis
sudo -u postgres createlang -d template_postgis plpgsql
sudo -u postgres psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis';"
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql
sudo -u postgres psql -d template_postgis -c "grant all on geometry_columns to public;"
sudo -u postgres psql -d template_postgis -c "grant all on geography_columns to public;"
sudo -u postgres psql -d template_postgis -c "grant all on spatial_ref_sys to public;"
sudo -u postgres createdb -T template_postgis mydb
//sudo -u postgres psql -d mydb -f sample.sql
sudo -u postgres psql -f sample.sql mydb
sudo -u postgres psql mydb
select postgis_lib_version();
select postgis_full_version();
select version();
postgis_lib_version
---------------------
1.5.3
(1 row)
postgis_full_version()
----------------------
"POSTGIS="1.5.3" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8" USE_STATS"
version
---------------------
"PostgreSQL 9.1.3 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit"
分享到:
相关推荐
GlowRoot Install and Use Guaid , JVM monitor,Http track,API Request Tracke,Sql Query time。
mycat2 install-template(mycat2-install-template-1.21.zip)
mycat2 install-template(mycat2-install-template-1.20.zip)
AXAPTA aif use,create.
roller install guide roller user guide roller template guide
Through BDB you can also derive existing database and create an automatically installing program of the database. 2. cross-database platform: only need to give a definition accoding to the familiar ...
Through BDB you can also derive existing database and create an automatically installing program of the database. 2. cross-database platform: only need to give a definition accoding to the familiar ...
Install and configure the Oracle Database Appliance with confidence. Make the right choices between the various configurations in order to realize your performance requirements. Manage and monitor ...
This concise tutorial walks you step-by-step through the process, showing you exactly what you need to know to install, create, and support a successful Oracle 8i or 9i environment with Web ...
•Install and configure Oracle Database 12c Release 2 Real Application Clusters •Configure and manage disk groups using Oracle Automatic Storage Management •Work with services, voting disks, and ...
Oracle Database 11g Release 2 (11.2.0.3) RAC On Oracle Linux 6.3 Using VirtualBox This article describes the installation of Oracle Database 11g release...Install the Database Check the Status of the RAC
apt-get install erlang-nox # 安装erlang erl # 查看relang语言版本,成功执行则说明relang安装成功 2、添加公钥 wget -O- https://www.rabbitmq.com/rabbitmq-release-signing-key.asc | sudo apt-key add ...
一款用于制作安装程序的软件,此款为free版,虽有功能限制,但能满足一般需求。
Reporting Services Book Excerpt - Brian Larson
Install and configure Oracle NoSQL Database for optimal performance Develop complex, distributed applications using a rich set of APIs Read and write data into the Oracle NoSQL Database key-value ...
This book assumes no prior database experience and teaches you, always through hands–on examples, how to create and use relational databases with SQL and how to access them with C#. Almost every ...
如何解决TOMCAT的Tomcat's administration web application is no longer installed by default. Download and install the admin package to use it.
He describes how to install and create Docker images. and the advantages off Docker containers.The remainder of the book is devoted to discussing using Docker with important software solutions. He ...
This chapter discusses how to install the Oracle software and database. It also describes how to configure additional databases, and how to upgrade and older version of a database to the current ...