Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

PGCasts 02 - Controlando acessos

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

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

Avatar for Sebastian Webber

Sebastian Webber

July 11, 2016

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
250
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
110
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
170
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
160
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
240
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
110
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
390
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
150
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
420

Other Decks in Technology

See All in Technology
Vibe Coding で作ったプロダクトをどう安全に動かすか / How to Safely Run Products Built with Vibe Coding
Avatar for Akira Maeda glidenote
0
220
おい、エージェントを使って終わらせろ
Avatar for nwiizo nwiizo
2
730
.NET WebAssemblyで実現するクライアントサイドAI推論：NuGetからViteまで、2つのエコシステムを繋ぐビルド戦略
Avatar for Yusuke Yamada yamachu
0
210
ソフトウェアDNAとクラウドエージェントのススメ
Avatar for Cloud Ace cloudace
0
120
山手線を徒歩で一周してわかった、 位置情報アプリは「足」が最強のデバッガー
Avatar for hinakko hinakko
0
170
ADKで始める業務改善 - AIエージェント開発時の考えと設計
Avatar for Kazuki Hara harappa80
2
230
Deployment の 先にある AI Agent 基盤 - kagent vNext、Agent Substrate、Hermes から読み解く Agent Runtime の現在地 / k8s-matsuri-2-ai-agent-platform-amsy810
Avatar for Masaya Aoyama (@amsy810) masayaaoyama
4
670
Reactの設計論
Avatar for uhyo uhyo
24
14k
Minecraft JavaのMODをSwiftで作る
Avatar for 1mash0 1mash0
0
180
What the customer really needed
Avatar for Yasunobu Kawaguchi kawaguti
PRO
3
210
アクセスキーこわい やめかたと漏らさない工夫
Avatar for Yuichi Sato sassssan68
1
460
【技術的負債conf】事業成長に伴う技術的負債の説明責任とAIによるモニタリング、認知的負債について
Avatar for Masato Ishigaki / 石垣雅人 i35_267
3
1.8k

Featured

See All Featured
Visualization
Avatar for Eitan Lees eitanlees
152
17k
How to Build an AI Search Optimization Roadmap - Criteria and Steps to Take #SEOIRL
Avatar for Aleyda Solis aleyda
1
2.2k
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
1.6k
Marketing Yourself as an Engineer | Alaka | Gurzu
Avatar for Gurzu gurzu
0
300
Building an army of robots
Avatar for Kyle Neath kneath
307
46k
The Language of Interfaces
Avatar for Des Traynor destraynor
162
27k
Faster Mobile Websites
Avatar for Dean Hume deanohume
310
32k
Neural Spatial Audio Processing for Sound Field Analysis and Control
Avatar for NII S. Koyama's Lab skoyamalab
0
510
Groundhog Day: Seeking Process in Gaming for Health
Avatar for Sebastian Deterding codingconduct
0
360
Art, The Web, and Tiny UX
Avatar for Lynn Fisher lynnandtonic
304
22k
4 Signs Your Business is Dying
Avatar for Josh Pigford shpigford
187
23k
GitHub's CSS Performance
Avatar for Jon Rohan jonrohan
1033
470k

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