How to install PostgreSQL Database Server on Linux server

Optimizing and customizing your VPS/Dedicated server

How to install PostgreSQL Database Server on Linux server

Postby Mark » Wed Dec 23, 2009 8:58 am

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 !
Mark
 
Posts: 124
Joined: Fri Dec 11, 2009 2:18 pm

Return to Configuring VPS/Dedicated servers

Who is online

Users browsing this forum: No registered users and 1 guest

cron