Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
PGCasts 02 - Controlando acessos
Search
Sebastian Webber
July 11, 2016
Technology
0
130
PGCasts 02 - Controlando acessos
Controlando acessos ao servidor PostgreSQL
Sebastian Webber
July 11, 2016
Tweet
Share
More Decks by Sebastian Webber
See All by Sebastian Webber
Corrupção de dados: de onde vem? do que se alimenta?
sebastianwebber
0
160
12+ factor databases
sebastianwebber
0
17
Tests for dummies
sebastianwebber
0
110
Prometheus 101
sebastianwebber
0
44
Monitorando seu banco na nuvem
sebastianwebber
0
140
Monitorando sistemas distribuidos
sebastianwebber
1
55
SRE for Dummies
sebastianwebber
0
260
Prometheus_Dojo.pdf
sebastianwebber
0
59
Como ser um DBA na era DEVOPS?
sebastianwebber
0
290
Other Decks in Technology
See All in Technology
継続的な改善 x ⾮連続的な進化
sansantech
PRO
3
150
JAWS-UG Bedrock Claude Night
yamahiro
3
560
Delivering Millions of Messages within seconds @ Duolingo
pelelgrino
0
350
[新卒向け研修資料] テスト文字列に「うんこ」と入れるな(2024年版)
infiniteloop_inc
3
12k
ChatworkのSRE部って実は 半分くらいPlatform Engineering部かもしれない
saramune
0
160
プラットフォームってつくることより計測することが重要なんじゃないかという話 / Platform Engineering Meetup #8
taishin
1
350
KubeCon EU 2024 Recap “Kubernetes Policy Time Machine: Where to Next?”
ryysud
0
210
ChatGPT for IT Service Management (IT Pro)
dahatake
7
1.5k
MLOpsの「壁」を乗り越える、LINEヤフーの Data Quality as Code
lycorptech_jp
PRO
5
470
MySQL の SQL クエリチューニングの要所を掴む勉強会
andpad
2
6.1k
長期間TiDBを使ってきた話 @ 私たちはなぜNewSQLを使うのかTiDB選定5社が語る選定理由と活用LT / Experiences with TiDB Over Time
chibiegg
2
890
KubeConにproposalを送りたい人へのアドバイス
sat
PRO
3
240
Featured
See All Featured
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
501
140k
Fontdeck: Realign not Redesign
paulrobertlloyd
76
4.9k
Build The Right Thing And Hit Your Dates
maggiecrowley
24
2k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
322
20k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
21
1.6k
Teambox: Starting and Learning
jrom
128
8.4k
Designing on Purpose - Digital PM Summit 2013
jponch
110
6.5k
Imperfection Machines: The Place of Print at Facebook
scottboms
260
12k
Music & Morning Musume
bryan
41
5.6k
Thoughts on Productivity
jonyablonski
58
3.8k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
274
13k
Documentation Writing (for coders)
carmenintech
60
3.9k
Transcript
PostgreSQL Screencasts 02
• CEntOS 7.X • PostgreSQL 9.5 • http://bit.ly/pgcast_ vagrant
'*' • 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
Situação antes do primeiro acesso.
Situação após o primeiro acesso.
• https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html • Faça reload no banco de dados pra
aplicar as mudanças
# firewall-cmd --get-active-zones # firewall-cmd --zone=public --add-port=5432/tcp -–permanent # firewall-cmd
--reloadsuccess
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