2014年03月_batilei

12月 11月 10月 08月 07月 06月 05月 03月 02月 01月

原创 PostgreSQL special sql 1 - list all the columns and primary key

There are a few special sql commands that I used often recently, mark them here.1: Show all the columns' nameSELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='yourtablename';

2014-03-30 04:40:31 901

原创 Transfer postgres database to another server - backup and restore

Currently I want to transfer all my local database to the remote server and I found a very simple solution. (1) Backup your database [1] (2) Transfer the backup to the destination server. (3)

2014-03-29 00:14:29 694

原创 Create Remote Database Server - PostgreSQL

As I said yesterday that I tried to create a remote PostgreSQL database on the Ubuntu Server hosted by DigitalOcean. After I created the PostgreSQL, I met some problems connecting to the remote databa

2014-03-28 01:15:51 773

原创 Install The PostgreSQL on the Ubuntu Server hosted by the Digital Ocean

Today I tried to install the postgresql on the ubuntu server hosted by the digital ocean like[1]. It should be a quite easy task. But I kept getting errors when I typed the command "psql", the error s

2014-03-27 09:55:31 1493

原创 Install PostgreSql and PostGIS On Ubuntu Server

There is an article[1] for installing PostgreSQL on Ubuntu. [2] actually is a even better one if you want to install PostgreSQL and PostGIS at the same time. In order to use PostGIS in database, yo

2014-03-27 02:52:48 822

原创 Openstack Exploring - nova list no output

I have read some documents and they all say that the command "nova list" can output all the instances[1]. But when I try, nothing output. Then I search and got a good explanation in [2].[1

2014-03-23 07:21:48 682

原创 Openstack Learning- Floating IP Related

Today when I used Openstack, I made a mistake. Because of some debug issues I created a Ubuntu image while changing its /etc/network/interfaces to static IP[1], which makes the OpenStack can't not as

2014-03-23 06:54:30 804

原创 Use JSP with Eclipse in Ubuntu

(1)Install Tomcat7 in Ubuntu:It is very easy to install tomcat7 in ubuntu. Just refer to[1], (1)type the command:sudo apt-get install tomcat7, (2) check the website http://localhost:8080/I

2014-03-04 08:30:34 1066