Re: [INTERFACES] pg_pwd problem, 2nd try - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] pg_pwd problem, 2nd try
Date
Msg-id 26301.951261706@sss.pgh.pa.us
Whole thread Raw
In response to pg_pwd problem, 2nd try  ("Ken J. Wright" <ken@ori-ind.com>)
Responses Re: [INTERFACES] pg_pwd problem, 2nd try  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-interfaces
"Ken J. Wright" <ken@ori-ind.com> writes:
> If I use the ALTER USER sql statement, the file pg_pwd gets written in an
> older plain text format & the user can no longer authenticate. However,
> using pg_passwd from the command line reates a file similar to /etc/passwd
> including the username and an encrypted password. Known problem?

It is now ;-)

Peter changed the backend's idea about the format of pg_pwd, but
I guess he forgot about pg_passwd ...

I wonder whether we even need pg_passwd in its present form anymore.
Maybe it should just issue an ALTER USER command?
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Vanbeckevoort Gert
Date:
Subject: pgaccess connection err. with postmaster -i
Next
From: Peter Eisentraut
Date:
Subject: Re: [INTERFACES] pg_pwd problem, 2nd try