On Fri, Jul 14, 2006 at 03:21:01PM +0400, Eugene Prokopiev wrote: > Hi, > > Is it possible to read cleartext user password from pgsql database? In > this link > http://www.postgresql.org/docs/8.1/interactive/view-pg-user.html > explained that password always reads as ********. But I need to use > pgsql login/password as authentication info for another service.
You can't get back the cleartext password, it's hashed. To see the hashed password you need to bypass the view, see pg_shadow. The docs should say something about how the hash is calcualted. Hope this helps, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
