PGCasts 02 - Controlando acessos

6f3efd5477238ca18957c723854ec795?s=47 Sebastian Webber
July 11, 2016
Technology
0
110

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

6f3efd5477238ca18957c723854ec795?s=128

Sebastian Webber

July 11, 2016
Tweet

More Decks by Sebastian Webber

See All by Sebastian Webber
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
66
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
5
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
86
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
18
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
120
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
26
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
100
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
16
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
110

Other Decks in Technology

See All in Technology
2102a6b8760bd6f57f672805723dd83a?s=48 line_developers_tw
0
710
0d29d155ce5c5a93ed46363626da3ea7?s=48 ocise
1
1.9k
2ec42cd8400b1e8e5ba125936c1d27e9?s=48 smiyaza
0
190
C636093440dd4a8be6416e83cb980979?s=48 iselegant
13
2.6k
C265a1a7dadb2713ff2262025e91d133?s=48 akabekobeko
0
450
332f89cc697355902a817506b6995f2b?s=48 ytaka23
0
330
098ad475722e3697ec2fba28c8654f9f?s=48 yuhta28
0
390
C79a3191aa67cae35282fb129587696b?s=48 hendrikebbers
0
100
0d29d155ce5c5a93ed46363626da3ea7?s=48 ocise
1
1.9k
9e7a653ed313b3da4b263a772bfc5026?s=48 clustervr
0
190
332f89cc697355902a817506b6995f2b?s=48 ytaka23
1
960
A581dece94e3a97b391d3d17b10cf084?s=48 fnario
0
150

Featured

See All Featured
C157b16234f1e75e8eac3698c1d4414a?s=48 ddemaree
273
31k
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
682
180k
Fde6c3a50ca518a909ef35c22c0ee0e4?s=48 destraynor
145
19k
C7393b7ba7ec9c8890dd77d209fbb3c9?s=48 maltzj
499
36k
95d9f37115fbb0d13135d0f77132f856?s=48 morganepeng
11
710
719435d98d452de7ac367c828266cf01?s=48 erikaheidi
12
3.9k
Ba530e786553390f3fb271848485681c?s=48 3n
161
22k
A0517b08532aec8ab2aae3f65d40ad86?s=48 hannesfritz
27
890
D09fad3e36ae6841f54820be0e907f7a?s=48 rocio
155
11k
E4f5d494ebdc9e7cce1aecf3ce3e8bc1?s=48 shpigford
165
18k
D8fc2580cfaca035f666d9e4ee79a7f7?s=48 mongodb
23
3.7k
91cefdf141106fa10674aae74ce05890?s=48 yeseniaperezcruz
297
31k

Transcript

  1. PostgreSQL Screencasts 02

  2. • CEntOS 7.X • PostgreSQL 9.5 • http://bit.ly/pgcast_ vagrant

  3. '*' • https://www.postgresql.org/docs/current/static/runtime-config- connection.html#GUC-LISTEN-ADDRESSES • Faça restart no banco de

    dados pra aplicar as mudanças

  4. Situação antes do primeiro acesso.

  5. Situação após o primeiro acesso.

  6. • https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html • Faça reload no banco de dados pra

    aplicar as mudanças

  7. # firewall-cmd --get-active-zones # firewall-cmd --zone=public --add-port=5432/tcp -–permanent # firewall-cmd

    --reloadsuccess

  8. Teste acesso ao postmaster Faça revisão e ajustes do firewall

    listen_addresses = '*' ajustes no pg_hba.conf Lista de ferramentas úteis: • nmap • telnet • psql