owenn panng wrote:
> Hi there, I was wondering what is needed to done on both the postgres
> & client side to connect via MD5.
with 7.4.x and 8, at least, you don't need to do anything special, the client
libraries take care of it transparently. the pg_shadow file is created
automatically when you use
ALTER USER username WITH ENCRYPTED PASSWORD 'password';
as a SQL statement. (actually, it appears it uses $PGDATA/global/pg_pwd for
this if you don't specify anything else).