Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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
77
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
7
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
98
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
27
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
170
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
30
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
120
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
17
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
130

Other Decks in Technology

See All in Technology
2c51cbf972b0de2e0696c8a26c7d1f4b?s=48 matsuihidetoshi
2
800
49c19cca70c23c71d0f86da45be2eb61?s=48 puttyo__
0
100
179d41d0fdd38c6980de9f2ae0e4768a?s=48 9wick
0
320
Bac74c17d65c22d0ae63915251f7750f?s=48 simboss
1
170
Ecad9d801d79f6c6e5df93094690685e?s=48 sinsoku
6
1.7k
462feb0fe0493c40d55650da664e8773?s=48 clustervr
PRO
0
150
De266761b955b2636e454a1bc7a99ed4?s=48 masayaaoyama
0
880
97d180294474e9df01503148f3b11f39?s=48 lambda
0
210
211c8e4e5b96c116670c00cd77ebe2c1?s=48 rigolon
1
250
53850955f15249a1a9dc49df6113e400?s=48 line_developers
PRO
1
190
6fa7408f5f53132d0ba0d52f6afae9dc?s=48 monsieurverde
0
230
64fdeeb10dba981472bf5a90dae23f2a?s=48 ryoheig0405
0
220

Featured

See All Featured
E4f5d494ebdc9e7cce1aecf3ce3e8bc1?s=48 shpigford
166
19k
4262b9cfacfb6b2c77f23e1d0310cd3e?s=48 myddelton
109
11k
6bb82b13cda86d3b821fa44100335ddf?s=48 thoeni
4
710
168ccec72eee0530b818d44f3fedaacf?s=48 shlominoach
176
7.7k
11c84dff30266b907714802088852677?s=48 jasonvnalue
83
8.2k
027d1ebf66cc039a0bd3b55eeadbe75d?s=48 sachag
267
17k
4394ceb8b277f35ee3da7030384efb5d?s=48 davidbonilla
72
3.6k
B83d5b590577969ee79a5ad845411a7d?s=48 ammeep
657
54k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
120
8.1k
Fde6c3a50ca518a909ef35c22c0ee0e4?s=48 destraynor
146
19k
2bb923c57a1fdc3a2eb484bb8d565fd2?s=48 ufuk
58
5.5k
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
120
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