pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Where are password hashes stored?
4+ messages / 3 participants
[nested] [flat]

* Where are password hashes stored?
@ 2021-03-22 17:59 Ron <ronljohnsonjr@gmail.com>
  2021-03-22 18:01 ` Re: Where are password hashes stored? Stephen Frost <sfrost@snowman.net>
  2021-03-22 18:01 ` Re: Where are password hashes stored? Scott Ribe <scott_ribe@elevated-dev.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Ron @ 2021-03-22 17:59 UTC (permalink / raw)
  To: Pgsql-admin <pgsql-admin@lists.postgresql.org>

This is v9.6, if it matters.

I need to send a screenshot of roles and their password hashes, but I can't 
seem to find the relevant table, and Google only shows pages about .pgpass 
and crypto.

Thanks.

-- 
Angular momentum makes the world go 'round.





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Where are password hashes stored?
  2021-03-22 17:59 Where are password hashes stored? Ron <ronljohnsonjr@gmail.com>
@ 2021-03-22 18:01 ` Stephen Frost <sfrost@snowman.net>
  2021-03-22 18:02   ` Re: Where are password hashes stored? Ron <ronljohnsonjr@gmail.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Stephen Frost @ 2021-03-22 18:01 UTC (permalink / raw)
  To: Ron <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>

Greetings,

* Ron (ronljohnsonjr@gmail.com) wrote:
> This is v9.6, if it matters.
> 
> I need to send a screenshot of roles and their password hashes, but I can't
> seem to find the relevant table, and Google only shows pages about .pgpass
> and crypto.

pg_authid

Thanks,

Stephen

Attachments:

  signature.asc (application/pgp-signature, 818B) download

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Where are password hashes stored?
  2021-03-22 17:59 Where are password hashes stored? Ron <ronljohnsonjr@gmail.com>
  2021-03-22 18:01 ` Re: Where are password hashes stored? Stephen Frost <sfrost@snowman.net>
@ 2021-03-22 18:02   ` Ron <ronljohnsonjr@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Ron @ 2021-03-22 18:02 UTC (permalink / raw)
  To: Stephen Frost <sfrost@snowman.net>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>

On 3/22/21 1:01 PM, Stephen Frost wrote:
> Greetings,
>
> * Ron (ronljohnsonjr@gmail.com) wrote:
>> This is v9.6, if it matters.
>>
>> I need to send a screenshot of roles and their password hashes, but I can't
>> seem to find the relevant table, and Google only shows pages about .pgpass
>> and crypto.
> pg_authid
>
Thanks.
> Thanks,

>
> Stephen

-- 
Angular momentum makes the world go 'round.





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Where are password hashes stored?
  2021-03-22 17:59 Where are password hashes stored? Ron <ronljohnsonjr@gmail.com>
@ 2021-03-22 18:01 ` Scott Ribe <scott_ribe@elevated-dev.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Scott Ribe @ 2021-03-22 18:01 UTC (permalink / raw)
  To: Ron <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>

> On Mar 22, 2021, at 11:59 AM, Ron <ronljohnsonjr@gmail.com> wrote:
> 
> This is v9.6, if it matters.
> 
> I need to send a screenshot of roles and their password hashes, but I can't seem to find the relevant table, and Google only shows pages about .pgpass and crypto.
> 
> Thanks.

select * from pg_shadow;







^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2021-03-22 18:02 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-22 17:59 Where are password hashes stored? Ron <ronljohnsonjr@gmail.com>
2021-03-22 18:01 ` Stephen Frost <sfrost@snowman.net>
2021-03-22 18:02   ` Ron <ronljohnsonjr@gmail.com>
2021-03-22 18:01 ` Scott Ribe <scott_ribe@elevated-dev.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox