PostgreSQL is an object-relational database management system (ORDBMS). It is released under a BSD-style license and is thus
free software. As with many other open-source programs, PostgreSQL is not controlled by any single company, but relies on a global community of developers and companies to develop it.
Here are the simple steps on getting it installed on your Linux Server /
VPS Hosting through SSH:
Quote:
Download : http://www.postgresql.org/ftp/source/
./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/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test
|
Enjoy a new flavour of SQL Server DB server ! 