237
edições
Linha 291: | Linha 291: | ||
com | com | ||
<syntaxhighlight lang="sh">cat /etc/postgresql/14/main/pg_hba.conf | <syntaxhighlight lang="sh">sudo cat /etc/postgresql/14/main/pg_hba.conf | ||
sed -E -i 's/local(\s+)all(\s+)postgres(\s+)peer/local\1all\2postgres\3trust/' /etc/postgresql/14/main/pg_hba.conf | sudo sed -E -i 's/local(\s+)all(\s+)postgres(\s+)peer/local\1all\2postgres\3trust/' /etc/postgresql/14/main/pg_hba.conf | ||
sed -E -i 's/local(\s+)all(\s+)all(\s+)peer/local\1all\2all\3trust/' /etc/postgresql/14/main/pg_hba.conf | sudo sed -E -i 's/local(\s+)all(\s+)all(\s+)peer/local\1all\2all\3trust/' /etc/postgresql/14/main/pg_hba.conf | ||
sed -E -i 's;host(\s+)all(\s+)all(\s+)127.0.0.1/32(\s+)scram-sha-256;host\1all\2all\3127.0.0.1/32\4trust;' /etc/postgresql/14/main/pg_hba.conf | sudo sed -E -i 's;host(\s+)all(\s+)all(\s+)127.0.0.1/32(\s+)scram-sha-256;host\1all\2all\3127.0.0.1/32\4trust;' /etc/postgresql/14/main/pg_hba.conf | ||
sudo service postgresql restart | sudo service postgresql restart | ||
cat /etc/postgresql/14/main/pg_hba.conf</syntaxhighlight> | sudo cat /etc/postgresql/14/main/pg_hba.conf</syntaxhighlight> | ||
== Criar diretórios, grupos == | == Criar diretórios, grupos == |
edições