http://blog.9cbs.net/sharDy/archive/2004/08/13/73690.aspx
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:
./configuregmakesugmake installadduser postgresmkdir / usr / local / pgsql / datachown postgres / usr / local / pgsql / datasu - postgres / usr / local / pgsql / bin / initdb -D / usr / local / pgsql / data / usr / local / pgsql / bin / postmaster -d / usr / local / pgsql / data> logfile 2> & 1 & / usr / local / pgsql / bin / createb test / usr / local / pgsql / bin / psql test installation under Windows, need to use Cygwin, this 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.
