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
150
0

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

Avatar for Sebastian Webber

Sebastian Webber

July 11, 2016

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
250
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
110
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
160
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
150
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
230
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
100
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
380
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
140
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
420

Other Decks in Technology

See All in Technology
名刺メーカーDevグループ 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
1.2k
サイバー捜査員研修（後半）
Avatar for Nomizo Nomizo nomizone
1
580
名古屋の市バスGTFS-JPデータ×スガキヤ 最寄りバス停検索をAmazon ElastiCache Serverless for Valkeyで最適化する
Avatar for usanchuu usanchuu
1
250
AIが自社のTableauを操作する世界へ：Tableau MCP超入門
Avatar for Yukako Tabata tbtykk
0
110
PLaMoを毎日の開発で使い育てていく
Avatar for Preferred Networks pfn
PRO
0
180
AI ネイティブな組織に Gemini Enterprise Agent Platform がなぜ必要なのか
Avatar for Asei Sugiyama asei
1
170
もう一度考える SRE チームの作り方・育て方 / Rethinking SRE #1: Building and Growing SRE Teams
Avatar for rrreeeyyy rrreeeyyy
5
970
AIは実装を速くする。では、私たちは何を今作るべきか？－立場を越えてリリースに向き合ったチーム開発の実践 / 20260801 Hiromi Nakaya and Naoki Takahashi
Avatar for SHIFT EVOLVE shift_evolve
PRO
3
370
[しろおび夏祭り2026] チャットするAIから、作業するAIへ - 使われ方の変化と、その裏側で起きていること
Avatar for kk0n kk0n
0
1.5k
QAタスクをスキル化したいときに考えること
Avatar for aomoriringo aomoriringo
0
180
修正PRを食べてレビュースキルが賢くなる：Claude Codeによる自己改善サイクル
Avatar for um(うめ) yuyaumetsu
4
990
つくって納得、つかって実感！ 大規模言語モデルことはじめ ver2.0
Avatar for Recruit recruitengineers
PRO
2
470

Featured

See All Featured
Exploring the relationship between traditional SERPs and Gen AI search
Avatar for Ray Grieselhuber raygrieselhuber
PRO
2
4.2k
Facilitating Awesome Meetings
Avatar for Lara Hogan lara
57
7.1k
Lightning Talk: Beautiful Slides for Beginners
Avatar for Ines Montani inesmontani
PRO
2
620
From Legacy to Launchpad: Building Startup-Ready Communities
Avatar for Dug Song dugsong
0
280
What’s in a name? Adding method to the madness
Avatar for The Alliance productmarketing
PRO
24
4.1k
KATA
Avatar for Megan Lloyd mclloyd
PRO
35
15k
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
420
Music & Morning Musume
Avatar for Bryan Veloso bryan
47
7.3k
Highjacked: Video Game Concept Design
Avatar for Ryan Kendrick rkendrick25
PRO
1
420
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
38
2.9k
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
408
67k
It's Worth the Effort
Avatar for 3n 3n
188
29k

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