Installing PostgreSQL 8.3 on Debian Linux is pretty easy. With this command it is done.
apt-get install postgresql-8.3
Now the DB system is installed under:
/etc/postgresql/8.3/
You can see the status of the RDBMS with this command:
/etc/init.d/postgresql-8.3 status
You can start it
/etc/init.d/postgresql-8.3 start
and you can stop it
/etc/init.d/postgresql-8.3 stop
After the successful installation there is also a “postgres” user on your system. You can set the password of this user with this command:
passwd postgres
Now you can login as postgres user with:
su postgres
And with this command you can create a database:
createdb testdatabase
Your DB ist up and running.