Upgrade to Pro — share decks privately, control downloads, hide ads and more …

PGCasts 02 - Controlando acessos

Avatar for Sebastian Webber Sebastian Webber
July 11, 2016
Technology
0
140

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

Avatar for Sebastian Webber

Sebastian Webber

July 11, 2016
Tweet

More Decks by Sebastian Webber

See All by Sebastian Webber
Corrupção de dados: de onde vem? do que se alimenta?
Avatar for Sebastian Webber sebastianwebber
0
210
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
56
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
140
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
100
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
190
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
83
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
350
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
100
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
370

Other Decks in Technology

See All in Technology
ゼロコード計装導入後のカスタム計装でさらに可観測性を高めよう
Avatar for SansanTech sansantech
PRO
1
450
ブラウザのAPIで Nintendo Switch用の特殊なゲーム用コントローラーを体験型コンテンツに / IoTLT @ストラタシス・ジャパン
Avatar for you（@youtoy） you
PRO
0
140
OCIjp_Oracle AI World_Recap
Avatar for Shinya Omori shinpy
1
180
オブザーバビリティと育てた ID管理・認証認可基盤の歩み / The Journey of an ID Management, Authentication, and Authorization Platform Nurtured with Observability
Avatar for 株式会社カミナシ kaminashi
1
720
生成AI時代のPythonセキュリティとガバナンス
Avatar for abenben abenben
0
140
OTEPsで知るOpenTelemetryの未来 / Observability Conference Tokyo 2025
Avatar for Arthur arthur1
0
250
OpenTelemetry が拡げる Gemini CLI の可観測性
Avatar for Tomonori Hayashi phaya72
2
2.3k
NLPコロキウム20251022_超効率化への挑戦: LLM 1bit量子化のロードマップ
Avatar for Yuma Ichikawa yumaichikawa
3
480
AI時代の開発を加速する組織づくり - ブログでは書けなかったリアル
Avatar for Hiro hiro8ma
1
310
Oracle Base Database Service 技術詳細
Avatar for oracle4engineer oracle4engineer
PRO
14
82k
dbtとAIエージェントを組み合わせて見えたデータ調査の新しい形
Avatar for 10xinc 10xinc
1
360
AI時代、“平均値”ではいられない
Avatar for uhyo uhyo
8
2.6k

Featured

See All Featured
Fireside Chat
Avatar for paigeccino paigeccino
41
3.7k
Put a Button on it: Removing Barriers to Going Fast.
Avatar for kastner kastner
60
4k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
Avatar for Kevin Liebholz kevinliebholz
36
6.1k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
34
2.3k
Bash Introduction
Avatar for André Augusto Costa Santos 62gerente
615
210k
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
97
6.3k
How to Ace a Technical Interview
Avatar for Jacob Kaplan-Moss jacobian
280
24k
Into the Great Unknown - MozCon
Avatar for Noah Learner thekraken
40
2.1k
Facilitating Awesome Meetings
Avatar for Lara Hogan lara
57
6.6k
Navigating Team Friction
Avatar for Lara Hogan lara
190
15k
Site-Speed That Sticks
Avatar for Harry Roberts csswizardry
13
930
Reflections from 52 weeks, 52 projects
Avatar for Jefferson Lam jeffersonlam
353
21k

Transcript

  1. PostgreSQL Screencasts 02

  2. • CEntOS 7.X • PostgreSQL 9.5 • http://bit.ly/pgcast_ vagrant

  3. '*' • 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

  4. Situação antes do primeiro acesso.

  5. Situação após o primeiro acesso.

  6. • https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html • Faça reload no banco de dados pra

    aplicar as mudanças

  7. # firewall-cmd --get-active-zones # firewall-cmd --zone=public --add-port=5432/tcp -–permanent # firewall-cmd

    --reloadsuccess

  8. 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