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.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s