On 10:06 Tue 19 Jun , Jeffrey Webster wrote: > On 6/17/07, Andrej Ricnik-Bay <andrej.groups@xxxxxxxxx> wrote: > > > Hm. Why not just edit your .bash_profile, or .bashrc? (I won't go into > the details of which to use) > > Add: > export PGDATA=/usr/local/pgsql/data > > Add the following the line that sets your path: > :/usr/local/pgsql/bin > > It should now look something like: > > export PGDATA=/usr/local/pgsql/data > export PATH=$PATH:$HOME/bin:/usr/local/pgsql/bin > > If you put it in .bashrc just use the following to set the variables: > . ~/.bashrc > > Any new terminal you open will have those settings immediately. Solved it in the end, thanks. Debian puts the executables in /usr/lib/postgresql/8.1/bin/ Once I found that I was OK Now busy trying to migrate a bodge of a spreadsheet to something usable Regards, John -- War is God's way of teaching Americans geography Ambrose Bierce (1842 - 1914)
