Lock in $30 Savings on PRO—Offer Ends Soon! ⏳

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
220
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
65
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
150
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
110
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
190
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
86
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
350
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
110
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
370

Other Decks in Technology

See All in Technology
ブロックテーマとこれからの WordPress サイト制作 / Toyama WordPress Meetup Vol.81
Avatar for Toro_Unit (Hiroshi Urabe) torounit
0
370
グレートファイアウォールを自宅に建てよう
Avatar for 綿糸てせ ctes091x
0
130
形式手法特論：CEGAR を用いたモデル検査の状態空間削減 #kernelvm / Kernel VM Study Hokuriku Part 8
Avatar for y_taka_23 ytaka23
2
400
エンジニアリングマネージャー はじめての目標設定と評価
Avatar for d-haru halkt
0
210
Agentic AI Patterns and Anti-Patterns
Avatar for Guillaume Laforge glaforge
1
150
21st ACRi Webinar - AMD Presentation Slide (Nao Sumikawa)
Avatar for Nao Sumikawa nao_sumikawa
0
230
re:Invent 2025 ふりかえり 生成AI版
Avatar for TakaakiKakei takaakikakei
1
120
AI駆動開発によるDDDの実践
Avatar for ディップ株式会社 dip_tech
PRO
0
370
Oracle Database@Google Cloud：サービス概要のご紹介
Avatar for oracle4engineer oracle4engineer
PRO
0
660
Playwright x GitHub Actionsで実現する「レビューしやすい」E2Eテストレポート
Avatar for kinosuke01 kinosuke01
0
180
[JAWS-UG 横浜支部 #91]DevOps Agent vs CloudWatch Investigations -比較と実践-
Avatar for sh_fk2 sh_fk2
1
220
pmconf2025 - データを活用し「価値」へ繋げる
Avatar for Emy - Emiko Yoshihara glorypulse
0
630

Featured

See All Featured
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
52
3.5k
The Art of Programming - Codeland 2020
Avatar for Erika Heidi erikaheidi
56
14k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
249
1.3M
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
31
2.7k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
128
54k
Practical Orchestrator
Avatar for Shlomi Noach shlominoach
190
11k
What’s in a name? Adding method to the madness
Avatar for Product Marketing Alliance productmarketing
PRO
24
3.8k
Principles of Awesome APIs and How to Build Them.
Avatar for Keavy McMinn keavy
127
17k
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
30
5.7k
Typedesign – Prime Four
Avatar for Hannes Fritz hannesfritz
42
2.9k
Code Reviewing Like a Champion
Avatar for maltzj maltzj
527
40k
Performance Is Good for Brains [We Love Speed 2024]
Avatar for Tammy Everts tammyeverts
12
1.3k

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