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
140
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
210
12+ factor databases
sebastianwebber
0
56
Tests for dummies
sebastianwebber
0
140
Prometheus 101
sebastianwebber
0
100
Monitorando seu banco na nuvem
sebastianwebber
0
190
Monitorando sistemas distribuidos
sebastianwebber
1
83
SRE for Dummies
sebastianwebber
0
350
Prometheus_Dojo.pdf
sebastianwebber
0
100
Como ser um DBA na era DEVOPS?
sebastianwebber
0
370
Other Decks in Technology
See All in Technology
.NET 10のBlazorの期待の新機能
htkym
0
110
「最速」で Gemini CLI を使いこなそう! 〜Cloud Shell/Cloud Run の活用〜 / The Fastest Way to Master the Gemini CLI — with Cloud Shell and Cloud Run
aoto
PRO
1
180
20251027_findyさん_音声エージェントLT
almondo_event
2
430
Observability — Extending Into Incident Response
nari_ex
1
290
Wasmの気になる最新情報
askua
0
190
Implementing and Evaluating a High-Level Language with WasmGC and the Wasm Component Model: Scala’s Case
tanishiking
0
180
Linux カーネルが支えるコンテナの仕組み / LF Japan Community Days 2025 Osaka
tenforward
1
130
スタートアップの現場で実践しているテストマネジメント #jasst_kyushu
makky_tyuyan
0
130
QA業務を変える(!?)AIを併用した不具合分析の実践
ma2ri
0
140
AI駆動で進める依存ライブラリ更新 ─ Vue プロジェクトの品質向上と開発スピード改善の実践録
sayn0
1
300
ストレージエンジニアの仕事と、近年の計算機について / 第58回 情報科学若手の会
pfn
PRO
3
840
AIプロダクトのプロンプト実践テクニック / Practical Techniques for AI Product Prompts
saka2jp
0
110
Featured
See All Featured
Build your cross-platform service in a week with App Engine
jlugia
233
18k
The Invisible Side of Design
smashingmag
302
51k
The Power of CSS Pseudo Elements
geoffreycrofte
80
6k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
130k
Java REST API Framework Comparison - PWX 2021
mraible
34
8.9k
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
16
1.7k
A Tale of Four Properties
chriscoyier
161
23k
jQuery: Nuts, Bolts and Bling
dougneiner
65
7.9k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
127
54k
Typedesign – Prime Four
hannesfritz
42
2.8k
Intergalactic Javascript Robots from Outer Space
tanoku
272
27k
StorybookのUI Testing Handbookを読んだ
zakiyama
31
6.2k
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