Sep 17, 2010

Installing PostgreSQL database.

PostgreSQL is a very powerfull open source database. You can download the binary package or the source code by visitiing the website.
http://www.postgresql.org

I will describe how to install this by using the source code.

First of all you must download the source code from the website. It may like;
postgresql-.tar.bz2
Decompress the tar file.
Then change the directory into the decompressed diredtory.
Now you can see source files of the software.

Now type;
./configure
Then after that;
gmake
Then you should become a super user to comtinue the instalation.
For that type;
su
then if it ask for the password. Give the password and type,
gmake install

This will copy all files which needed to the software. But the instalation is not over. This database need an user called postgres. So to add this user to your system you must type;
useradd postgres
Then do these instructions
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
The last instruction will change the user root to postgres.

Also you should type some instructions to make the configuration files. For that;
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

/usr/local/pgsql/bin/postgres -D /user/local/pgsql/data >logfile 2>&1 &

So now you had compleated the instalation part.
Then you must create a database. For that,

/usr/local/pgsql/bin/createdb

To use that database;
/usr/local/pgsql/bin/pqsl

No comments:

Post a Comment

Your comments are always welcome ...