Postgresql binaries and directories

[keith284]

I've removed postgresql-8.1 and installed postgresql-8.2.4

however each time I type psql as a non-postgres user, it still looks for the 8.1 binary file. If I switch to the postgres user and execute psql, all is fine. Does anyone know how to fix this?


root@bla:/tmp # psql -l
bash: /usr/lib/postgresql/8.1/bin/psql: No such file or directory
root@bla:/tmp # su - postgres
postgres@bla:~$ psql -l
List of databases
Name | Owner | Encoding
------------+----------+-----------
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(3 rows)

postgres@bla:~$

Thank you in advance,

 

[stefanwagner]

which psql

will tell you, which psql is used.

ls -l $(which psql)

shows, whether it is a symbolic link (to nowhere).



don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung

 

[keith284]

Thanks stefanwagner.

A colleague of mine later found out that I was aliasing psql from .bashrc >_<; now I feel very VERY stupid.

 

[feherke]

Hi

Then another useful command for next time in such situation :

[blue]master #[/blue] type psql
psql is /usr/bin/psql

[gray]# or[/gray]

[blue]master #[/blue] type psql
psql aliased to `psql --nasty-parameter'

Feherke.

http://rootshell.be/~feherke/