PostgreSQL is a very mature Open source database with a good performance and support for SQL. It supports the stored procedure. The industry is also very high. Recently, I have a little understanding of him, I have installed it under Linux and WINDOW. And tested him through JDBC.
Installing under Linux As soon as the document is done, as follows:
./configure
gmake
SU
Gmake install
AddUser Postgres
MKDIR / USR / local / PGSQL / DATA
Chown Postgres / USR / local / PGSQL / DATA
Su - Postgres
/ usr / local / pgsql / bin / initdb -d / usr / local / pgsql / data
/ usr / local / pgsql / bin / postmaster -d / usr / local / pgsql / data> Logfile 2> & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 &
/ usr / local / pgsql / bin / createdb test
/ usr / local / pgsql / bin / psql test
In Windows installation, you need to use CygWin, which is a program that simulates the Linux environment under Windows. He offers a lot of Open Source software running under Cygwin, such as: OpenLDAP, OpenSSL, etc. When you install Cygwin, you will automatically install PostgreSQL, but you need to run CygServer before running PostgreSQL, remember that CygServer is in the / user / sbin directory, if not, you need to download and install.
When using the JDBC to connect to the database, you need to pay attention to the client to connect to PostgreSQL, you need to register in pg_hba.conf. Specify username, client IP address, and permissions.
