Skip site navigation (1) Skip section navigation (2)

Re: Про pg_dumpall

From: Peter Teslenko <smartchecker(at)gmail(dot)com>
To: pgsql-ru-general(at)postgresql(dot)org
Subject: Re: Про pg_dumpall
Date: 2008-03-28 16:06:26
Message-ID: 47ED1782.8080804@gmail.com (view raw or flat)
Thread:
Lists: pgsql-ru-general
Alexey Klyukin wrote:

> В современных версиях PostgreSQL pg_dumpall делает select from pg_authid, 
> пароль в которой хранится в виде хэша:
> 
> template1=#select * from pg_authid ;
>   rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb |
>   rolcatupdate | rolcanlogin | rolconnlimit |             rolpassword
>   | rolvaliduntil | rolconfig 
>   ---------+----------+------------+---------------+-------------+--------------+-------------+--------------+-------------------------------------+---------------+-----------
>    alexk   | t        | t          | t             | t           | t
>    | t           |           -1 | md5a8f1a184a0c7d72d2743b9315359c9d8 |
>    | 
>    (1 row)

А как быть, если я хочу посмотреть именно пароль? Или это уже невозможно?

-- 
Peter Teslenko
Jabber: peter(at)jabber(dot)mcicb(dot)ru

In response to

Responses

pgsql-ru-general by date

Next:From: dewilDate: 2008-03-28 16:18:52
Subject: Re: Про pg_dumpall
Previous:From: Alexey KlyukinDate: 2008-03-28 15:34:42
Subject: Re: Пр pg_dumpall

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group