Thanks for the response.

The following are versions I checked:

postgres, createdb, dropdb, pg_dump and pg_restore - 7.4.7

I did an ldd for each of createdb, dropdb, pg_dump and pg_restore. The
output was - /usr/lib/libpq.so.3 for all of them.

All these have been linked with the same libpq library. So, thinking
wht could be the problem?

-Anu

Using .pgpass is a behavior of libpq, which underlies utilities
like pg_dump, createdb, and dropdb. If createdb and dropdb are
linked against a libpq from PostgreSQL 7.3 or later, then they
should be using .pgpass. Have you done a process trace or examined
the access time of .pgpass to test your hypothesis that createdb
and dropdb don't use it? Have you used the --version option to
verify that the correct versions of those utilites are being used,
or ldd to see which libpq they're linked against?

createdb and dropdb make connections to template1. Have you checked
pg_hba.conf to see if connecting to template1 is different than
connecting to other databases?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

"Sankaran Anupama" <sanupama (AT) novell (DOT) com> writes:
I just tried it here, and 7.4.8 createdb definitely picks up .pgpass
for me. It seems like you must have some local breakage, but I'm not
sure what ... we've eliminated the obvious ideas.

Did you build these programs from source? If not, where'd you get them?
What's the platform exactly?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly