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
240
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
人手不足への挑戦:車両保全を支えるIoTとクラウド内製化の道【SORACOM Discovery 2026】
Avatar for SORACOM（ソラコム） soracom
PRO
0
170
システム監視を 「システムを監視するだけ」で 終わらせないために
Avatar for sei_ud seiud
0
160
クラウドを使う側から、作る側へ / 大吉祥寺.pm 2026前夜祭
Avatar for FUJIWARA Shunichiro fujiwara3
8
1.9k
クラウドセキュリティ入門　～安全なクラウド利用のための基礎知識～
Avatar for LHazy lhazy
0
1.1k
ソフトウェアアーキテクチャ研修【MIXI 26新卒技術研修】
Avatar for MIXI ENGINEERS mixi_engineers
PRO
2
1k
AI工学特論: MLOps・継続的評価
Avatar for Asei Sugiyama asei
11
3.1k
CloudWatchから始めるAWS監視
Avatar for butadora butadora
0
300
「休む」重要さ
Avatar for Makky12 smt7174
7
1.8k
13年運用タイトルのサーバーサイドが辿り着いた現在地 ― モンスターストライクにおける技術・組織・AI活用から得た知見
Avatar for MIXI ENGINEERS mixi_engineers
PRO
1
350
脱Jenkins、インターン生が挑んだCIツールGitHubActions移行
Avatar for MIXI ENGINEERS mixi_engineers
PRO
1
290
Atlassian Cloudサポート業務でのAIエージェント活用事例
Avatar for Makky12 smt7174
0
150
害獣害虫を自動判別！ ペストコントロール支援ビジネス成功のヒント【SORACOM Discovery 2026】
Avatar for SORACOM（ソラコム） soracom
PRO
0
130

Featured

See All Featured
StorybookのUI Testing Handbookを読んだ
Avatar for Shingo Yamazaki zakiyama
31
6.9k
GraphQLの誤解/rethinking-graphql
Avatar for sonatard sonatard
75
12k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
Avatar for mongodb mongodb
49
10k
How to Think Like a Performance Engineer
Avatar for Harry Roberts csswizardry
28
2.7k
Into the Great Unknown - MozCon
Avatar for Noah Learner thekraken
41
2.6k
Bootstrapping a Software Product
Avatar for Garrett Dimon garrettdimon
PRO
307
120k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k
GitHub's CSS Performance
Avatar for Jon Rohan jonrohan
1033
470k
Game over? The fight for quality and originality in the time of robots
Avatar for Wayne Barker wayneb77
1
230
DevOps and Value Stream Thinking: Enabling flow, efficiency and business value
Avatar for Helen Beal helenjbeal
1
270
Skip the Path - Find Your Career Trail
Avatar for Mark Kilby mkilby
1
170
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.4k

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