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
180
12+ factor databases
sebastianwebber
0
18
Tests for dummies
sebastianwebber
0
110
Prometheus 101
sebastianwebber
0
51
Monitorando seu banco na nuvem
sebastianwebber
0
140
Monitorando sistemas distribuidos
sebastianwebber
1
57
SRE for Dummies
sebastianwebber
0
280
Prometheus_Dojo.pdf
sebastianwebber
0
71
Como ser um DBA na era DEVOPS?
sebastianwebber
0
310
Other Decks in Technology
See All in Technology
突撃! 隣のAmazon Bedrockユーザー 〜YouはどうしてAWSで?〜
minorun365
PRO
3
390
Classmethod AI Talks(CATs) #1 司会進行スライド(2024.09.19) / classmethod-ai-talks-aka-cats_moderator-slides_vol1_2024-09-19
shinyaa31
0
140
実務における脅威モデリングを考えよう
nikinusu
0
700
なにもしてないのにNew Relicのデータ転送量が増えていたときに確認したこと
tk3fftk
2
230
アプリをリリースできる状態に保ったまま 段階的にリファクタリングするための 戦略と戦術 / Strategies and tactics for incremental refactoring
yanzm
6
1.5k
「認証認可」という体験をデザインする ~Nekko Cloud認証認可基盤計画
logica0419
2
450
あなたの知らないiOS開発の世界
recruitengineers
PRO
3
190
「自動テストのプラクティスを効果的に学ぶためのカードゲーム」 ( #sqip2024 )
teyamagu
PRO
2
190
QAに対する超個人的な解釈 / Personal Take on QA
toma_sm
1
140
より快適なエラーログ監視を目指して
leveragestech
4
1.5k
『GRANBLUE FANTASY: Relink』クオリティと物量の両立に挑戦したフェイシャルアニメーション事例 ~カットシーンからランタイムまで~
cygames
0
120
学術機関におけるID連携とOpenID Connect
fujie
0
300
Featured
See All Featured
How to train your dragon (web standard)
notwaldorf
85
5.6k
Learning to Love Humans: Emotional Interface Design
aarron
270
40k
The Mythical Team-Month
searls
218
43k
YesSQL, Process and Tooling at Scale
rocio
167
14k
Building Flexible Design Systems
yeseniaperezcruz
325
38k
The Cult of Friendly URLs
andyhume
76
6k
What's new in Ruby 2.0
geeforr
340
31k
How GitHub (no longer) Works
holman
310
140k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
26
1.3k
A designer walks into a library…
pauljervisheath
201
24k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
363
22k
Design by the Numbers
sachag
277
19k
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