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
220
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
67
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
150
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
110
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
200
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
86
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
350
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
110
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
380

Other Decks in Technology

See All in Technology
AWSに革命を起こすかもしれない新サービス・アップデートについてのお話
Avatar for Yuuki Yamashita yama3133
0
540
田舎で20年スクラム（後編）：一個人が企業で長期戦アジャイルに挑む意味
Avatar for Tomonori Fukuta chinmo
1
110
ESXi のAIOps だ！2025冬
Avatar for Unno Wataru unnowataru
0
450
戰略轉變：從建構 AI 代理人到發展可擴展的技能生態系統
Avatar for Bo-Yi Wu appleboy
0
170
AWS re:Inventre:cap ～AmazonNova 2 Omniのワークショップを体験してきた～
Avatar for NRI Netcom nrinetcom
PRO
0
120
Agent Skillsがハーネスの垣根を超える日
Avatar for Gota gotalab555
7
5.1k
[PR] はじめてのデジタルアイデンティティという本を書きました
Avatar for ritou ritou
0
680
BidiAgent と Nova 2 Sonic から​考える音声 AI について
Avatar for Yuuki Yamashita yama3133
2
140
スクラムマスターが
スクラムチームに入って取り組む5つのこと
- スクラムガイドには書いてないけど入った当初から取り組んでおきたい大切なこと -
Avatar for scrummasudar scrummasudar
0
460
[2025-12-12]あの日僕が見た胡蝶の夢 〜人の夢は終わらねェ AIによるパフォーマンスチューニングのすゝめ〜
Avatar for tosite tosite
0
230
さくらのクラウド開発ふりかえり2025
Avatar for kazeburo kazeburo
2
1.3k
Strands Agents × インタリーブ思考 で変わるAIエージェント設計 / Strands Agents x Interleaved Thinking AI Agents
Avatar for Takanori Suzuki takanorig
6
2.5k

Featured

See All Featured
Side Projects
Avatar for Sacha Greif sachag
455
43k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
Amusing Abliteration
Avatar for ianozsvald ianozsvald
0
79
Designing Experiences People Love
Avatar for Jonathan Moore moore
143
24k
[SF Ruby Conf 2025] Rails X
Avatar for Vladimir Dementyev palkan
0
660
AI Search:
Where Are We & What Can We Do About It?
Avatar for Aleyda Solis aleyda
0
6.8k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
254
22k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
Avatar for Addy Osmani addyosmani
9
1k
Max Prin - Stacking Signals: How International SEO Comes Together (And Falls Apart)
Avatar for Tech SEO Connect techseoconnect
PRO
0
57
Context Engineering - Making Every Token Count
Avatar for Addy Osmani addyosmani
9
570
Collaborative Software Design: How to facilitate domain modelling decisions
Avatar for Kenny Baas-Schwegler baasie
0
110
Facilitating Awesome Meetings
Avatar for Lara Hogan lara
57
6.7k

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