Installing PostgreSQL 8.3 on Debian Linux (leny)

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.

Published by Robert Reiz

CEO @ VersionEye. Passionated software developer since 1998.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: