Hi Stuart. I don't find any 'ident' in my pg_hba.conf. So where is the mistake? please keep teaching me. ====here is my pg_hba.conf postgres@acer-suse:~/data/base/rumahsakit> whoami postgres postgres@acer-suse:~/data/base/rumahsakit> pwd /var/lib/pgsql/data/base/rumahsakit ....<<SNIP>>.... # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all password # IPv4 local connections: host all all 127.0.0.1/32 password host all all 0.0.0.0 0.0.0.0 password # IPv6 local connections: host all all ::1/128 md5 postgres@acer-suse:~/data/base/rumahsakit> whoami postgres postgres@acer-suse:~/data/base/rumahsakit> pwd /var/lib/pgsql/data/base/rumahsakit postgres@acer-suse:~/data/base/rumahsakit> ====/etc/sysconfig/postgresql postgres@acer-suse:/etc/sysconfig> pwd /etc/sysconfig postgres@acer-suse:/etc/sysconfig> cat postgresql ## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "~postgres/data" ## ServiceRestart: postgresql # # In which directory should the PostgreSQL database reside? # POSTGRES_DATADIR="~postgres/data" ## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "" ## ServiceRestart: postgresql # # The options that are given to the PostgreSQL master daemon on startup. # See the manual pages for postmaster and postgres for valid options. # # Don't put "-D datadir" here since it is set by the startup script # based on the variable POSTGRES_DATADIR above. # POSTGRES_OPTIONS="-i" ## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "C" ## ServiceRestart: "" # # Specifies the locale under which the PostgreSQL database location # should be initialized and run. If needed, it has to be changed # before PostgreSQL is started for the first time. To change the # locale of an existsing PostgreSQL database location, it must be # dumped, removed and initialized from scratch using the new locale. # # If unset or empty $RC_LANG from /etc/sysconfig/language is used. # POSTGRES_LANG="" postgres@acer-suse:/etc/sysconfig> On Sat, 2006-01-21 at 16:42 -0500, Stuart wrote:
Patix,
Sounds like you have an entry in your pg_hba.conf file that tells psql to go to pg_ident.conf to verify the user patrix or possibly all users. Check your pg_hba.conf file and remove references to ident. Check any default statements that might include ident.
On Saturday 21 January 2006 14:38, Patrix Linux wrote:
pg_hba.conf'