hi this following words from Dinesh did worked for me. Thanks guys and really appreciate your help and advice. PG_DATA=/usr/local/pgsql/data regards suresh ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend