Hi All,
I have tried the following steps, and it works smoothly on Ubuntu, hope this little contribution can help you in installing and setting up PostgreSQL.
PostgreSQL:
PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
Installation Instructions
Download:
Download latest version of PostgreSQL from the following link for linux
http://www.enterprisedb.com/products/pgdownload.do#linux
After downloading change the downloaded file mode using the following command
sudo chmod a+x file_name.bin
Installation
use the following command
sudo ./file_name.bin
Follow the instructions and i will lead to install sucessfully.
All The Best,
Narasimha Raju. Naidu
India