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
200
12+ factor databases
sebastianwebber
0
30
Tests for dummies
sebastianwebber
0
120
Prometheus 101
sebastianwebber
0
74
Monitorando seu banco na nuvem
sebastianwebber
0
160
Monitorando sistemas distribuidos
sebastianwebber
1
66
SRE for Dummies
sebastianwebber
0
300
Prometheus_Dojo.pdf
sebastianwebber
0
79
Como ser um DBA na era DEVOPS?
sebastianwebber
0
330
Other Decks in Technology
See All in Technology
Developer Summit 2025 [14-D-1] Yuki Hattori
yuhattor
19
6.3k
速くて安いWebサイトを作る
nishiharatsubasa
11
13k
Classmethod AI Talks(CATs) #16 司会進行スライド(2025.02.12) / classmethod-ai-talks-aka-cats_moderator-slides_vol16_2025-02-12
shinyaa31
0
110
Cloud Spanner 導入で実現した快適な開発と運用について
colopl
1
720
エンジニアのためのドキュメント力基礎講座〜構造化思考から始めよう〜(2025/02/15jbug広島#15発表資料)
yasuoyasuo
18
6.9k
『衛星データ利用の方々にとって近いようで触れる機会のなさそうな小話 ~ 衛星搭載ソフトウェアと衛星運用ソフトウェア (実物) を動かしながらわいわいする編 ~』 @日本衛星データコミニティ勉強会
meltingrabbit
0
150
Culture Deck
optfit
0
430
RECRUIT TECH CONFERENCE 2025 プレイベント【高橋】
recruitengineers
PRO
0
160
2024.02.19 W&B AIエージェントLT会 / AIエージェントが業務を代行するための計画と実行 / Algomatic 宮脇
smiyawaki0820
14
3.5k
Nekko Cloud、 これまでとこれから ~学生サークルが作る、 小さなクラウド
logica0419
2
980
株式会社EventHub・エンジニア採用資料
eventhub
0
4.3k
リーダブルテストコード 〜メンテナンスしやすい テストコードを作成する方法を考える〜 #DevSumi #DevSumiB / Readable test code
nihonbuson
11
7.3k
Featured
See All Featured
Art, The Web, and Tiny UX
lynnandtonic
298
20k
Making Projects Easy
brettharned
116
6k
The Straight Up "How To Draw Better" Workshop
denniskardys
232
140k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
33
2.1k
The MySQL Ecosystem @ GitHub 2015
samlambert
250
12k
For a Future-Friendly Web
brad_frost
176
9.5k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
100
18k
Being A Developer After 40
akosma
89
590k
How STYLIGHT went responsive
nonsquared
98
5.4k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
59k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
47
5.2k
The Cult of Friendly URLs
andyhume
78
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