Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOOse-0006k9-BD for pgsql-admin@arkaria.postgresql.org; Mon, 22 Mar 2021 18:02:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lOOsd-0007LJ-8B for pgsql-admin@arkaria.postgresql.org; Mon, 22 Mar 2021 18:02:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOOsd-0007LA-0M for pgsql-admin@lists.postgresql.org; Mon, 22 Mar 2021 18:02:19 +0000 Received: from mail-ot1-x330.google.com ([2607:f8b0:4864:20::330]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lOOsa-00028h-Sv for pgsql-admin@lists.postgresql.org; Mon, 22 Mar 2021 18:02:18 +0000 Received: by mail-ot1-x330.google.com with SMTP id f73-20020a9d03cf0000b02901b4d889bce0so16822314otf.12 for ; Mon, 22 Mar 2021 11:02:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=gBfMcdngBAJH4sxbccLHoqljaAXI2cLbYwOzXP1ugGg=; b=vIHLnh7aWqVwTA0s0K632ZCDKHVnOOO9SzOinpEZgsPYc+HYtYjTUOVHyHbQh5K/Z1 PBVFZF+0gYsvDUEqqWr6aURcPb4GmimsyToOF6zYGfxIMIhP5rYencMr3Mm4vOi3ij4w YyDFuMw0sv3jkjgTvkFIqWGGU+RmPXE9CFEB0yk5WH/uDNZcIx0Zflyt60jc76nAEowj o8PrwoUvB6ld7I55vvFTIrhctPCPh96jndF24wUd5SQynyFFevF8igva9qN2rl9SzTp5 SOMTpXcV9khjJhCNHByuBwGRo9QPhZAcGqmLHv3IjPrdTLKRbiqLnLKYX8/eUpoex8oL +DIQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=gBfMcdngBAJH4sxbccLHoqljaAXI2cLbYwOzXP1ugGg=; b=gH/YmPby/NzxzXJ79wfnhkJUhIwi1DaqGpWmkvgX9tZZBrwp1HfF6E6dGW+TEVtfvx bsvDbEgG9cRk4D2KKRUlBJ4QBoeGc/ESGfYHTtEhEPgfTf3InyJwYjVwJYp2RYvMA8zQ LLRigL2ha+L1RkJ+hCBKNoa6qo1Ryb2YsV24OAu8wSbQhtGzDs7cCn92yxzByEREBmbQ 3l7Z2NTp7f0XuMikvLb+dNrHokSf8t9/sE0jzA/O6+fXgfOtLTjHdHcW8LNGZPLLZAVK 1TDQfRZV9Y3AvwkvvJytSkizpRnnT5uaHA2UDMWHOiVWuERKUm5Kw4o3bLBm5kpmNgog fgGw== X-Gm-Message-State: AOAM530hobS4zIb3ORTKCqcqZzonT+tTrTdgjnOzLn2kFC95xBnaqHHn r4lNFvja3t+U2ev5744YqoqcH8uu8U0= X-Google-Smtp-Source: ABdhPJz44EDb95tetkpGsDI+SADCIWAI5Nl5hs2juAGMyJEV0tqF9lO7V8UP/AqSnDMZSFGXYzIhjA== X-Received: by 2002:a05:6830:23ad:: with SMTP id m13mr889158ots.121.1616436135210; Mon, 22 Mar 2021 11:02:15 -0700 (PDT) Received: from [192.168.88.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id t19sm3608299otm.40.2021.03.22.11.02.14 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 22 Mar 2021 11:02:14 -0700 (PDT) Subject: Re: Where are password hashes stored? To: Stephen Frost Cc: Pgsql-admin References: <20210322180117.GE20766@tamriel.snowman.net> From: Ron Message-ID: Date: Mon, 22 Mar 2021 13:02:13 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <20210322180117.GE20766@tamriel.snowman.net> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.