citusdata / citusdata/citus

password is plaintext while use pg_dist_authinfo

Open
#6,449 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

Please give me some help. T_T

I am using citus for building database cluster, one cn and two worker node.
for authentication, I use pg_dist_authinfo:

```
select * from pg_dist_authinfo;
nodeid | rolename | authinfo
--------+-----------+-----------------------
0 | role_1 | password=Test@2022
```
but the password show in plaintext, which is not allow in my server environments;

how can i solve this problem? Is there a switch to control ciphertext or plaintext while querying pg_dist_authinfo?
or some encryption and decryption solutions ?
or some other authentication solutions can I choose ?

thank you very much!

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.