Jayadevan M <maymala.jayadevan@xxxxxxxxx> writes: > I am able to login as postgres with password from the same machine. So it > is not an expiry issue (as you too concluded). Output from strace is about > 500 lines. I am pasting what I feel may be relevant. I hope this will be > useful. Well, this is pretty interesting: > open("/dev/tty", O_RDONLY) = 3 > open("/dev/tty", O_WRONLY|O_CREAT|O_TRUNC, 0666) = 4 > ioctl(3, SNDCTL_TMR_TIMEBASE or TCGETS, 0x7fffc631e550) = -1 ENOTTY > (Inappropriate ioctl for device) > ioctl(3, SNDCTL_TMR_CONTINUE or TCSETSF, {B0 -opost -isig icanon -echo > ...}) = -1 ENOTTY (Inappropriate ioctl for device) > fstat(4, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0 > mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = > 0x7fb252e41000 > write(4, "Password: ", 10) = 10 > fstat(3, {st_mode=S_IFREG|0644, st_size=10, ...}) = 0 > mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = > 0x7fb252e40000 > read(3, "Password: ", 4096) = 10 > read(3, "", 4096) = 0 > read(3, "", 4096) = 0 > ioctl(3, SNDCTL_TMR_CONTINUE or TCSETSF, {B0 -opost -isig icanon -echo > ...}) = -1 ENOTTY (Inappropriate ioctl for device) > write(4, "\n", 1) = 1 > close(3) = 0 > munmap(0x7fb252e40000, 4096) = 0 > close(4) = 0 It *is* prompting for a password, or so it thinks. Apparently /dev/tty is connected to the bit bucket in your environment? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general