I don't remember why it's deprecated. These days it seems to use the
same prompting mechanism as we use for passwords, so hopefully there
is no security risk. Maybe it should be un-deprecated? I'd tend to
take out the forced password prompt if we did, though.
regards, tom lane