Save 37% off PRO during our Black Friday Sale! »

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
81
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
10
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
100
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
32
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
180
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
31
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
150
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
31
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
130

Other Decks in Technology

See All in Technology
7e6a435700dda6cdb22105d601f20892?s=48 picardparis
4
2.9k
D907136acebc72f1df878541b26f271a?s=48 pichuang
1
180
57e80b356ed7005ee31e3494cdbfd02c?s=48 biatunky
1
180
D1b28ca276bee52e56ba11785f70d2d6?s=48 makocchi
2
220
0b7298e627d58afa8fd074ad47b34f73?s=48 wakama
0
280
26afa82334d1037f0ba602272b950c90?s=48 kazuhitotakahashi
0
230
997716e957fe4db19491b2794346a7ce?s=48 airreader
0
290
88b514e6413838c0d0cfb3257cefd19d?s=48 kamata_shingo
3
630
A857277d74d4719f7f7751dca5ed553e?s=48 cmusudakeisuke
0
600
D0a6969000c3715087b3a00abd646d20?s=48 timeseriesfr
0
220
23f4d5d797a91b6d17d627b90b5a42d9?s=48 kentaro
0
490
0b238801605070def81a98cfe8061aee?s=48 shonansurvivors
2
430

Featured

See All Featured
3d4519fd34b76fb265fc0237f3792bd4?s=48 danielanewman
208
20k
1519587b1a0febb658c36c94f6272b0d?s=48 roundedbygravity
249
21k
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
443
29k
B47b288784fda77a94aeb234ca743c24?s=48 keavy
111
15k
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
148
20k
E43f8dfd01057f8304f5f8fb9a294d7d?s=48 jeffersonlam
335
17k
25c7c18223fb42a4c6ae1c8db6f50f9b?s=48 mojombo
364
63k
95d9f37115fbb0d13135d0f77132f856?s=48 morganepeng
32
2.6k
E195ae45320d9202eaa01c9f1d31a416?s=48 marktimemedia
15
750
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
122
16k
B6a8f005f39d23ffc930508ac9da68b9?s=48 vanstee
123
5.2k
E4f5d494ebdc9e7cce1aecf3ce3e8bc1?s=48 shpigford
167
19k

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