I just discovered that SuSE provides the sample pg_hba.conf in /usr/share/pgsql
but the real pg_hba.conf file is located in /var/lib/pgsql/data Fixed! ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match