{{anchor href="top"}}
Hits : **{{hits}}**
== PostgreSQL ==
http://www.postgresql.org
http://www.postgresql.gr
((#top))
-----------
=== Requiments ===
bison
libreadline5-dev
((#top))
-----------
=== Download ===
%%(code)
wget -c ftp://ftp.postgresql.org/pub/source/v8.3.5/postgresql-8.3.5.tar.bz2
tar jxvf postgresql-8.3.5.tar.bz2
cd postgresql-8.3.5
%%
((#top))
-----------
=== Installation ===
%%(code)
./configure
gmake
su
gmake install
%%
((#top))
-----------
=== Post-Installation ===
Ως διαχειριστής :
%%(code)
# echo "/usr/local/pgsql/lib/" >> /etc/ld.so.conf
# ldconfig
# echo "export -p PATH=$PATH:/usr/local/pgsql/bin/" >> .bashrc
# echo "export -p MAN_PATH=$MAN_PATH:/usr/local/pgsql/man/" >> .bashrc
# source .bashrc
%%
((#top))
-----------
=== Creating a Database User ===
%%(code)
$ su -
# adduser postgres
# mkdir -pv /usr/local/pgsql/data
# chown postgres /usr/local/pgsql/data
%%
((#top))
-----------
=== Creating a Database Cluster ===
%%(code)
# su - postgres
$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
%%
((#top))
-----------
=== Starting the Database ===
%%(code)
$ su -
# mkdir -pv /var/log/postgreSQL
# chown -R postgres.postgres /var/log/postgreSQL/
# su - postgres
$ /usr/local/pgsql/bin/pg_ctl start -l /var/log/postgreSQL/logfile -D /usr/local/pgsql/data
%%
((#top))
-----------
=== Status & Stop Database ===
%%(code)
su - postgres
$ pg_ctl status -D /usr/local/pgsql/data
$ pg_ctl stop -D /usr/local/pgsql/data
%%
((#top))
-----------