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

PGCasts 02 - Controlando acessos

Avatar for Sebastian Webber Sebastian Webber
July 11, 2016
Technology
0
140

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

Avatar for Sebastian Webber

Sebastian Webber

July 11, 2016
Tweet

More Decks by Sebastian Webber

See All by Sebastian Webber
Corrupção de dados: de onde vem? do que se alimenta?
Avatar for Sebastian Webber sebastianwebber
0
210
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
53
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
140
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
100
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
190
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
82
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
340
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
98
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
360

Other Decks in Technology

See All in Technology
5年目から始める Vue3 サイト改善 #frontendo
Avatar for Kihara, Takuya tacck
PRO
3
200
20250903_1つのAWSアカウントに複数システムがある環境におけるアクセス制御をABACで実現.pdf
Avatar for yhana yhana
3
520
ChatGPTとPlantUML/Mermaidによるソフトウェア設計
Avatar for gowhich501 gowhich501
1
120
エラーとアクセシビリティ
Avatar for Tajima Sachiko schktjm
1
1.2k
Language Update: Java
Avatar for Yuichi.Sakuraba skrb
2
280
Automating Web Accessibility Testing with AI Agents
Avatar for South maminami373
0
1.2k
roppongirb_20250911
Avatar for Kuniaki IGARASHI igaiga
0
160
実践！カスタムインストラクション＆スラッシュコマンド
Avatar for puku0x puku0x
0
310
生成AIでセキュリティ運用を効率化する話
Avatar for Tkay sakaitakeshi
0
400
Webブラウザ向け動画配信プレイヤーの 大規模リプレイスから得た知見と学び
Avatar for yud0uhu yud0uhu
0
230
2025年夏 コーディングエージェントを統べる者
Avatar for nwiizo nwiizo
0
130
La gouvernance territoriale des données grâce à la plateforme Terreze
Avatar for BlueHats bluehats
0
150

Featured

See All Featured
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
28
4k
Context Engineering - Making Every Token Count
Avatar for Addy Osmani addyosmani
1
18
ReactJS: Keep Simple. Everything can be a component!
Avatar for Pedro Nauck pedronauck
667
120k
GitHub's CSS Performance
Avatar for Jon Rohan jonrohan
1032
460k
The Psychology of Web Performance [Beyond Tellerrand 2023]
Avatar for Tammy Everts tammyeverts
49
3k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
131
19k
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
37
2.8k
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
33
8.8k
[RailsConf 2023] Rails as a piece of cake
Avatar for Vladimir Dementyev palkan
57
5.8k
Unsuck your backbone
Avatar for Amy Palamountain ammeep
671
58k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
Avatar for Stéphanie Walter stephaniewalter
285
13k
Faster Mobile Websites
Avatar for Dean Hume deanohume
309
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