Install postgresql-8.1 in debian

Before installing postgresql-8.1 you have to know any other version of postgresql in installed or not.Because debian etch allready have the postgresql-7.4. So first of all you run the command:

#aptitude search postgresql-7.4

If yes, then you remove it
#apt-get --purge remove postgresql-7.4

Now Install the new version 8.1
#apt-get install postgresql-8.1

After installation of postgresql, configure the files /etc/postgresql/8.1/main/pg_hba.conf and /etc/postgresql/8.1/main/postgresql.conf

#vim /etc/postgresql/8.1/main/pg_hba.conf
add
host all all 0.0.0.0/0 md5

for connecting the database out site from the network.

Now #vim /etc/postgresql/8.1/main/
ssl=false

listenaddress = '*'

save and close the files.
now restart the server as:
#/etc/init.d/postgresql-8.1 restart

Install pgadmin3 for GUI integration
#apt-get install pgadmin3