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
140
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
230
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
80
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
150
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
120
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
210
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
94
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
370
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
120
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
390

Other Decks in Technology

See All in Technology
LLMに何を任せ、何を任せないか
Avatar for an cap120
11
6.7k
昔話で振り返るAWSの歩み ～S3誕生から20年、クラウドはどう進化したのか～
Avatar for NRI Netcom nrinetcom
PRO
0
120
フルカイテン株式会社 エンジニア向け採用資料
Avatar for FULL KAITEN fullkaiten
0
11k
最大のアウトプット術は問題を作ること
Avatar for ryoAccount ryoaccount
0
210
Bref でサービスを運用している話
Avatar for Sugar Sato sgash708
0
210
JAWS DAYS 2026でAIの「もやっと」感が解消された話
Avatar for Makky12 smt7174
1
120
不確実性と戦いながら見積もりを作成するプロセス/mitsumori-process
Avatar for hiro@miraito hirodragon112
1
160
QA組織のAI戦略とAIテスト設計システムAITASの実践
Avatar for SansanTech sansantech
PRO
1
270
開発チームとQAエンジニアの新しい協業モデル -年末調整開発チームで実践する【QAリード施策】-
Avatar for kaomi kaomi_wombat
0
280
TUNA Camp 2026 京都Stage ヒューリスティックアルゴリズム入門
Avatar for terry-u16 terryu16
0
640
非同期・イベント駆動処理の分散トレーシングの繋げ方
Avatar for Ken ichikawaken
1
250
やさしいとこから始めるGitHubリポジトリのセキュリティ
Avatar for Yuta Matsumura tsubakimoto_s
3
2.1k

Featured

See All Featured
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
6k
Have SEOs Ruined the Internet? - User Awareness of SEO in 2025
Avatar for Akash Hashmi akashhashmi
0
300
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
230k
Between Models and Reality
Avatar for mayunak mayunak
2
250
Making the Leap to Tech Lead
Avatar for Ryan Cromwell cromwellryan
135
9.8k
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
239
140k
We Have a Design System, Now What?
Avatar for Morgane Peng morganepeng
55
8k
It's Worth the Effort
Avatar for 3n 3n
188
29k
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
39
3.1k
Jamie Indigo - Trashchat’s Guide to Black Boxes: Technical SEO Tactics for LLMs
Avatar for Tech SEO Connect techseoconnect
PRO
0
92
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
141
7.4k
A Guide to Academic Writing Using Generative AI - A Workshop
Avatar for Kenji Saito ks91
PRO
0
250

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