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
47
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
140
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
97
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
180
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
80
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
330
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
92
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
350

Other Decks in Technology

See All in Technology
ひとり情シスなCTOがLLMと始めるオペレーション最適化 / CTO's LLM-Powered Ops
Avatar for Mitsuki Ogasahara yamitzky
0
360
[TechNight #90-1] 本当に使える？ ZDMの 新機能を実践検証してみた
Avatar for oracle4engineer oracle4engineer
PRO
3
140
BrainPadプログラミングコンテスト記念LT会2025_社内イベント&問題解説
Avatar for BrainPad brainpadpr
0
150
TechLION vol.41～MySQLユーザ会のほうから来ました / techlion41_mysql
Avatar for sakaik sakaik
0
140
VCpp Link and Library - C++ breaktime 2025 Summer
Avatar for Akiko Kawai harukasao
0
220
本当に使える？AutoUpgrade の新機能を実践検証してみた
Avatar for oracle4engineer oracle4engineer
PRO
1
120
Azure AI Foundryでマルチエージェントワークフロー
Avatar for 瀬尾佳隆 seosoft
0
140
2年でここまで成長！AWSで育てたAI Slack botの軌跡
Avatar for iwamot iwamot
PRO
2
140
新卒3年目の後悔 〜機械学習モデルジョブの運用を頑張った話〜
Avatar for camay kameitomohiro
0
370
Welcome to the LLM Club
Avatar for Koichi ITO koic
0
130
～宇宙最速～ 2025年AWS Summit レポート
Avatar for satodesu satodesu
1
1k
A2Aのクライアントを自作する
Avatar for Ryunosuke Iwai rynsuke
1
150

Featured

See All Featured
10 Git Anti Patterns You Should be Aware of
Avatar for Lemi Orhan Ergin lemiorhan
PRO
657
60k
JavaScript: Past, Present, and Future - NDC Porto 2020
Avatar for David Neal reverentgeek
48
5.4k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
248
1.3M
Making Projects Easy
Avatar for Brett Harned brettharned
116
6.2k
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
28
5.4k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
Avatar for Chris Coyier chriscoyier
507
140k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
Avatar for mongodb mongodb
46
9.6k
4 Signs Your Business is Dying
Avatar for Josh Pigford shpigford
184
22k
Measuring & Analyzing Core Web Vitals
Avatar for Philip Tellis bluesmoon
7
480
Building a Modern Day 
E-commerce SEO Strategy
Avatar for Aleyda Solis aleyda
41
7.3k
Bash Introduction
Avatar for André Augusto Costa Santos 62gerente
614
210k
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
5.6k

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