Upgrade to PRO for Only $50/Year—Limited-Time Offer! 🔥

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
66
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
200
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
380

Other Decks in Technology

See All in Technology
AWSの新機能をフル活用した「re:Inventエージェント」開発秘話
Avatar for みのるん minorun365
2
460
MySQLのSpatial(GIS)機能をもっと充実させたい ～ MyNA望年会2025LT
Avatar for sakaik sakaik
0
120
投資戦略を量産せよ 2 - マケデコセミナー(2025/12/26)
Avatar for tomo gamella
0
430
Next.js 16の新機能 Cache Components について
Avatar for sutetotanuki sutetotanuki
0
190
NIKKEI Tech Talk #41: セキュア・バイ・デザインからクラウド管理を考える
Avatar for Ryosuke Sekido sekido
PRO
0
210
Strands AgentsとNova 2 SonicでS2Sを実践してみた
Avatar for Yuuki Yamashita yama3133
1
1.9k
ActiveJobUpdates
Avatar for Kuniaki IGARASHI igaiga
1
320
LayerX QA Night#1
Avatar for koyaman2 koyaman2
0
260
会社紹介資料 / Sansan Company Profile
Avatar for Sansan, Inc. sansan33
PRO
11
390k
Identity Management for Agentic AI 解説
Avatar for Naohiro Fujie fujie
0
470
Amazon Connect アップデート！ AIエージェントにMCPツールを設定してみた！
Avatar for Yosuke Suzuki ysuzuki
0
140
通勤手当申請チェックエージェント開発のリアル
Avatar for WHIsaiyo whisaiyo
3
470

Featured

See All Featured
The SEO Collaboration Effect
Avatar for Kristina Bergwall kristinabergwall1
0
310
Dominate Local Search Results - an insider guide to GBP, reviews, and Local SEO
Avatar for Greg Gifford greggifford
PRO
0
17
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
110
The State of eCommerce SEO: How to Win in Today's Products SERPs - #SEOweek
Avatar for Aleyda Solis aleyda
2
9.1k
Building Experiences: Design Systems, User Experience, and Full Site Editing
Avatar for Michelle Schulp Hunt marktimemedia
0
330
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
6.7k
Design of three-dimensional binary manipulators for pick-and-place task avoiding obstacles (IECON2024)
Avatar for konakalab konakalab
0
320
Music & Morning Musume
Avatar for Bryan Veloso bryan
46
7k
Claude Code どこまでも/ Claude Code Everywhere
Avatar for nwiizo nwiizo
61
50k
Practical Orchestrator
Avatar for Shlomi Noach shlominoach
190
11k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
Avatar for Tammy Everts tammyeverts
10
750

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