Tena Sakai wrote: > ~/bin/pg_ctl -D ~/bin reload It's quite unlikely that your data directory is "~/bin".
> As I looked at the pid file, there were three lines. The > first line seemed like the pid of the server process. The > second line indicates where the database cluster resides. > In my case it is /usr/local/pgsql/data. That should be your -D argument then. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
