Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

[GP] postgrepsql rights management

2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Permission control file pg_ hba.confs [gpadmin @ dw-greeplum-1 gpseg-1] $more pg_hba.conf

The format is as follows

# local DATABASE USER METHOD [OPTIONS] # Local login # host DATABASE USER CIDR-ADDRESS METHOD [OPTIONS] # how to log in to-h on host

# hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTIONS]

# hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTIONS] host replication gpadmin 10.0.3.15/32 trust

Local all gpadmin ident

Host all gpadmin 127.0.0.1/28 trust

Host all gpadmin 192.168.6.119/32 trust

Host all gpadmin 10.0.3.15/32 trust

Host all gpadmin:: 1/128 trust

Host all gpadmin fe80::a00:27ff:fe2b:8253/128 trust

Host all gpadmin fe80::a00:27ff:fe36:96e4/128 trust # trust trust, no need to enter password

Local replication gpadmin ident

Host replication gpadmin samenet trust

Host all all 0.0.0.0 md5 0 md5 # password is required

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report