Hi, On Thursday 07 September 2006 08:00, Iuri Sampaio wrote: | oacsbr@desktop:~$ env | grep PATH | PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games | | Funny thing, speaking about full paths... there is no psql command in | "/usr/bin/" that's because it's presumably installed under /usr/local/pgsql/bin -- look at the PATH variable for user postgres or check with "which psql" as user postgres. | oacsbr@desktop:~$ ls -l /usr/bin/psql | | ls: /usr/bin/psql: No such file or directory [...] | The postgres commands work fine to postgres user but it doesn't work to a | random user account | and set on .bashrc | | LD_LIBRARY_PATH=:/usr/local/pgsql/lib:/usr/local/pgsql/lib | | PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/local/pgsql/ |b in:/usr/local/pgsql/bin | you want to repeat this step for other users required to run the "psql" command. Ciao, Thomas -- Thomas Pundt <thomas.pundt@xxxxxxxxxxxx> ---- http://rp-online.de/ ----