I tested on Solaris AMD64 and Sparc v240 (64bit) and it works for me. Do
you use 32bit or 64bit version of postgreSQL and what you have in .pgpass?
Zdenek
Volodymyr Kostyrko wrote:
It seems to me that auth on the local interface(?) is broken somehow on
sparc64.
[data/pg_hba.conf]
local postgres,template1 all trust
local postgres,template1 all md5
host postgres,template1 all 0.0.0.0/0 md5
host postgres,template1 all ::/0 md5
[--]
Well, what I really want to do is to remove the trust line from config.
But that way i need a .pgpass file so the server can start/control
itself without asking me for password. And if i want .pgpass file i need
some auth.
[session transcript/same machine]
> psql -U pgsql postgres
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# alter role pgsql password 'somepass';
ALTER ROLE
postgres=# \q
> psql -h localhost -U pgsql postgres
Password for user pgsql:
psql: FATAL: password authentication failed for user "pgsql"
[--]
It fails for any user and any password.
[session transcript/other machine]
> psql -h blade -U pgsql postgres
Password for user pgsql:
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=#
[--]
But I can log from another machine flawlessly...
> uname -a
FreeBSD blade.lan 6.2-STABLE FreeBSD 6.2-STABLE #13: Tue Jun 5 17:06:57
EEST 2007 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/BLADE sparc64
PS: Can assist in debugging if someone would point me what and how.
---------------------------(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
