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
190
12+ factor databases
sebastianwebber
0
21
Tests for dummies
sebastianwebber
0
110
Prometheus 101
sebastianwebber
0
52
Monitorando seu banco na nuvem
sebastianwebber
0
140
Monitorando sistemas distribuidos
sebastianwebber
1
58
SRE for Dummies
sebastianwebber
0
290
Prometheus_Dojo.pdf
sebastianwebber
0
73
Como ser um DBA na era DEVOPS?
sebastianwebber
0
310
Other Decks in Technology
See All in Technology
分布で見る効果検証入門 / ai-distributional-effect
cyberagentdevelopers
PRO
4
700
Amazon_CloudWatch_ログ異常検出_導入ガイド
tsujiba
4
1.6k
君は隠しイベントを見つけれるか?
mujyun
0
290
顧客が本当に必要だったもの - パフォーマンス改善編 / Make what is needed
soudai
24
6.8k
Automated Promptingを目指すその前に / Before we can aim for Automated Prompting
rkaga
0
110
Figma Dev Modeで進化するデザインとエンジニアリングの協働 / figma-with-engineering
cyberagentdevelopers
PRO
1
430
ガバメントクラウド単独利用方式におけるIaC活用
techniczna
3
270
Nix入門パラダイム編
asa1984
2
200
IaC運用を楽にするためにCDK Pipelinesを導入したけど、思い通りにいかなかった話
smt7174
1
110
生成AIと知識グラフの相互利用に基づく文書解析
koujikozaki
1
140
マネジメント視点でのre:Invent参加 ~もしCEOがre:Inventに行ったら~
kojiasai
0
460
話題のGraphRAG、その可能性と課題を理解する
hide212131
4
1.5k
Featured
See All Featured
Rebuilding a faster, lazier Slack
samanthasiow
79
8.6k
jQuery: Nuts, Bolts and Bling
dougneiner
61
7.5k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
26
1.4k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
107
49k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
246
1.3M
The Power of CSS Pseudo Elements
geoffreycrofte
72
5.3k
Making Projects Easy
brettharned
115
5.9k
A Philosophy of Restraint
colly
203
16k
Done Done
chrislema
181
16k
Building Adaptive Systems
keathley
38
2.2k
Visualization
eitanlees
144
15k
It's Worth the Effort
3n
183
27k
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