Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
PGCasts 02 - Controlando acessos
Sebastian Webber
July 11, 2016
Technology
0
120
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
77
12+ factor databases
sebastianwebber
0
7
Tests for dummies
sebastianwebber
0
95
Prometheus 101
sebastianwebber
0
29
Monitorando seu banco na nuvem
sebastianwebber
0
120
Monitorando sistemas distribuidos
sebastianwebber
1
43
SRE for Dummies
sebastianwebber
0
230
Prometheus_Dojo.pdf
sebastianwebber
0
36
Como ser um DBA na era DEVOPS?
sebastianwebber
0
230
Other Decks in Technology
See All in Technology
Airdrop for Open Source Projects
epicsdao
0
350
230120 ガンダムの事例にみる自動化の対象 Haruka Oh!さん
comucal
PRO
0
120
2年で10→70人へ! スタートアップの 情報セキュリティ課題と施策
miekobayashi
1
210
AI Builderについて
miyakemito
0
780
ラズパイとGASで加湿器の消し忘れをLINEでリマインド&操作
minako__ph
0
130
GitHub Codespaces が拡げる開発環境、いつでもどこでも Visual Studio Code で!
dzeyelid
0
160
データベースの発表には RDBMS 以外もありますよ
maroon1st
0
230
私見「UNIXの考え方」/20230124-kameda-unix-phylosophy
opelab
0
160
DNS権威サーバのクラウドサービス向けに行われた攻撃および対策 / DNS Pseudo-Random Subdomain Attack and mitigations
kazeburo
5
1.2k
日本ディープラーニング協会主催 NeurIPS 2022 技術報告会講演資料
tdailab
0
1k
Dev Containers ことはじめ - 失敗から学ぶ開発環境運用法
streamwest1629
0
290
2022年に起きたフロントエンドの変化
sakito
29
17k
Featured
See All Featured
Learning to Love Humans: Emotional Interface Design
aarron
263
38k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
351
21k
Six Lessons from altMBA
skipperchong
15
2.3k
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
reverentgeek
175
9.1k
Side Projects
sachag
451
37k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
38
3.6k
Building a Scalable Design System with Sketch
lauravandoore
451
31k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
226
16k
Practical Orchestrator
shlominoach
178
8.9k
Building Better People: How to give real-time feedback that sticks.
wjessup
346
17k
YesSQL, Process and Tooling at Scale
rocio
159
12k
The Power of CSS Pseudo Elements
geoffreycrofte
52
4.3k
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