PostgreSQL 9.0's SQL Shell

I've installed PostgreSQL 9.0.2 in my system(OS: Ubuntu 10.04 64-bit) and it's running on port no. 5433.

The installation path for PostgreSQL 9.0.2 is:

/opt/PostgreSQL/9.0

But, whenever I'm trying to accesss my PostgreSQl 9.0.2 in my terminal through “psql” command, it is aborting from SQL shell:

souvik@souvik-desktop:~$ /opt/PostgreSQL/9.0/bin/psql -U postgres -h localhost -p 5433

psql (9.0.2)

Type "help" for help.

Cannot read termcap database;

using dumb terminal settings.

Aborted

I tried hard to solve this problem and finally I got the solution for the above problem. First, you need to go to your root privilege then do the following things:

root@souvik-desktop:~# echo $TERM

xterm

root@souvik-desktop:~# infocmp -C > /etc/termcap

root@souvik-desktop:~# export TERM=vt100

root@souvik-desktop:~# infocmp -C >> /etc/termcap

After this try to open SQL shell again:

souvik@souvik-desktop:~$ /opt/PostgreSQL/9.0/bin/psql -U postgres -h localhost -p 5433

psql (9.0.2)

Type "help" for help.

postgres=#

So, here it is DONE!!!!