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
65
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
4
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
85
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
15
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
110
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
25
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
98
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
16
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
110

Other Decks in Technology

See All in Technology
835671ae91e49b2637313b91dacda1db?s=48 tdys13
1
1.2k
A64ac825509279a770c13c6fc517f11a?s=48 kawaguti
0
120
5b392dc79d5b6d1dab580bf60e26fb7c?s=48 nitya
0
180
3115a782126be714b5f94d24073c957d?s=48 oracle4engineer
2
260
1f745ff900e1be51aedae18cae76593c?s=48 kurochan
0
1.7k
Dd672f13e7e17714700544cb355cbaba?s=48 kyoshimoto
1
110
Cd891a89dfec6ca7bd278b5f5bd87c90?s=48 tzkoba
1
370
881b1b57f1cbe3b66b017203f7cb2efb?s=48 nplusone
0
140
7a37d60769f6f3004adee19a8ff2c219?s=48 tunepolo
4
1.4k
5b47136bedcba2799edf4fcd27ea66d7?s=48 yaegashi
0
200
F3f3eec8682a76ed430054e8fd994f15?s=48 tmnakagawa
0
710
B440848190075251e012e587b82f54e2?s=48 czmirror
0
210

Featured

See All Featured
Fe6b81005d1553accd6b2a28f6a2bef1?s=48 phodgson
83
3.8k
C0390e8b11079f8761c0cd3274ed61cb?s=48 productmarketing
3
420
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
55
5.3k
D83926c323d4f9289f947b4b4e76b939?s=48 jensimmons
205
9.9k
245cee81a9c424266e5e401d844ea881?s=48 lara
168
9.1k
D36d2c1821af9249b69ff7f5ed60529b?s=48 tammielis
236
23k
A60068bce2e73de3a37ca9d2dbe36092?s=48 bryan
100
11k
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
435
28k
91cefdf141106fa10674aae74ce05890?s=48 yeseniaperezcruz
296
30k
719435d98d452de7ac367c828266cf01?s=48 erikaheidi
5
3.5k
96270e4c3e5e9806cf7245475c00b275?s=48 addyosmani
308
21k
9128d500301ae51524e887bb680f471d?s=48 caitiem20
300
16k

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