Thursday, November 20, 2008

How To Install And Setup PostgreSQL for Ubuntu

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

No comments: