[BUGS] password auth woes on sparc64/FreeBSD

2007-06-05 Thread Volodymyr Kostyrko
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 remov

Re: [BUGS] password auth woes on sparc64/FreeBSD

2007-06-12 Thread Volodymyr Kostyrko
Zdenek Kotala wrote: 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? I use sparc64 and my .pgpass file was like: localhost:5432:*:pgsql:password Actually i have already found the cause. Authoriz

[BUGS] unicode strings are not sorted alphabetically

2004-08-05 Thread Volodymyr Kostyrko
This applies to non-english strings (in my case - russian). I've stumbled upon it on version 7.3.4. ( PostgreSQL 7.4.3 on i386-portbld-freebsd5.2.1, compiled by GCC cc (GCC) 3.3.3 [FreeBSD] 20031106) The attached files where created with: pg_dump -U lib lib > database_dump psql lib lib -c "