Changing host configuration $ vi /var/lib/pgsql/8.4/data/pg_hba.conf Add postgresql to startup process $ chkconfig postgresql-8.4 on Start postgresql service $ service postgresql-8.4 start Access postgresql $ su - postgresql $ psql Create database postgres-# create database test List databases postgres-# \list Exit postgresql postgres-# \q (or \quit) Connect to database postgres-# \c test (\connect test)

First lets do an update before we start installing PostgreSQL $ yum update You can install PostgreSQL from CentOS Base repo or can do a search for the latest version and install it based on your needs. Method 1 describes manual setup and Method 2 indicates an install from CentOS base repo (more…)

There had often been talks and some times flame wars when there had been comparison between MySQL and PostgreSQL. Each database has its own strength and weaknesses. As an initiative, I thought to do a little research on this topic and to list down the common points gathered in a tabular format. (more…)

CakePHP commonly known as 'Cake' is easy to install and faster to configure. It needs Apache (with mod_rewrite enabled), Php 4.3.2 or higher, MySQL/PostgreSQL/other ODBC, ADODB compliant databases. XAMPP by ApacheFriends or MAMP has a complete installation of the above products which is an ultimate time saver. But, you should prefer installing each software individually in order to get a grip on the subject. You can download the latest release from http://cakeforge.org/frs/download.php/695/1.2.0.7962.tar.gz (more…)