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
27
Tests for dummies
sebastianwebber
0
120
Prometheus 101
sebastianwebber
0
67
Monitorando seu banco na nuvem
sebastianwebber
0
160
Monitorando sistemas distribuidos
sebastianwebber
1
62
SRE for Dummies
sebastianwebber
0
300
Prometheus_Dojo.pdf
sebastianwebber
0
76
Como ser um DBA na era DEVOPS?
sebastianwebber
0
320
Other Decks in Technology
See All in Technology
Storage Browser for Amazon S3
miu_crescent
1
350
ヤプリQA課題の見える化
gu3
0
150
[JAWS-UG新潟#20] re:Invent2024 -CloudOperationsアップデートについて-
shintaro_fukatsu
0
150
Unsafe.BitCast のすゝめ。
nenonaninu
0
150
シフトライトなテスト活動を適切に行うことで、無理な開発をせず、過剰にテストせず、顧客をビックリさせないプロダクトを作り上げているお話 #RSGT2025 / Shift Right
nihonbuson
3
1.5k
Opcodeを読んでいたら何故かphp-srcを読んでいた話
murashotaro
0
370
AWS re:Invent 2024 ふりかえり勉強会
yhana
0
700
Zero Data Loss Autonomous Recovery Service サービス概要
oracle4engineer
PRO
1
5k
AIエージェントに脈アリかどうかを分析させてみた
sonoda_mj
2
130
20241218_マルチアカウント環境におけるIAM_Access_Analyzerによる権限管理.pdf
nrinetcom
PRO
3
150
組織に自動テストを書く文化を根付かせる戦略(2024冬版) / Building Automated Test Culture 2024 Winter Edition
twada
PRO
26
7.1k
Amazon Q Developerで.NET Frameworkプロジェクトをモダナイズしてみた
kenichirokimura
1
140
Featured
See All Featured
Rebuilding a faster, lazier Slack
samanthasiow
79
8.8k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
3
230
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
226
22k
Statistics for Hackers
jakevdp
797
220k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
132
33k
A Philosophy of Restraint
colly
203
16k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
97
17k
Automating Front-end Workflow
addyosmani
1366
200k
Measuring & Analyzing Core Web Vitals
bluesmoon
5
190
For a Future-Friendly Web
brad_frost
176
9.5k
Large-scale JavaScript Application Architecture
addyosmani
510
110k
How to train your dragon (web standard)
notwaldorf
88
5.8k
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