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
100
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
98
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
ソニー銀行におけるビジネスアジリティ向上のためのクラウドシフト戦略
Avatar for srenext srenext
0
150
cccccc
Avatar for moznion moznion
0
1.9k
タスクの複雑さでモデルを選ぶ ── Thompson Samplingで動かす“トークン/コスト最適化
Avatar for satoh-y-0323 satohy0323
0
280
実装だけじゃない！ CCA-F取得エンジニアが教えるClaude Code開発プロセス活用術
Avatar for morimorikochan diggymo
2
650
美しいコードを書くためにF#を学んでみた話
Avatar for yud0uhu yud0uhu
1
410
「早く出す」より「事業に効く」 ── 顧客の業務サイクルから逆算するAI時代の二重ループ開発と「変化の設計者」 / devsumi2026
Avatar for Rakus_Dev rakus_dev
1
220
SRE本の知られざる名シーン / The Hidden Gems of Google SRE Book
Avatar for Narimichi Takamura nari_ex
1
370
世界、断片、モデル。そして理解
Avatar for SAKO Hiroshi ardbeg1958
1
110
事業価値を⽣み出すSREへ SREが担うべき意思決定の5層
Avatar for kenta_hi kenta_hi
2
3.5k
Foxgloveについて 実際にExtensionを開発して公開するまでの話 / About Foxglove: The Story of Developing and Releasing an Extension
Avatar for Ryo Kabutan ry0_ka
0
210
誤解だらけの開発生産性 / Myths and Misconceptions about Developer Productivity
Avatar for Masato Ishigaki / 石垣雅人 i35_267
1
240
Kaggleで成長するために意識したこと
Avatar for Chikuwabu prgckwb
2
310

Featured

See All Featured
Designing Experiences People Love
Avatar for Jonathan Moore moore
143
24k
From π to Pie charts
Avatar for Rasagy Sharma rasagy
0
230
How to Align SEO within the Product Triangle To Get 
Buy-In & Support - #RIMC
Avatar for Aleyda Solis aleyda
2
1.6k
Measuring Dark Social's Impact On Conversion and Attribution
Avatar for Stephen Akadiri stephenakadiri
2
230
Measuring & Analyzing Core Web Vitals
Avatar for Philip Tellis bluesmoon
9
880
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
Avatar for Rebecca Miller-Webster rmw
35
3.6k
Code Review Best Practice
Avatar for Trisha Gee trishagee
74
20k
Efficient Content Optimization with Google Search Console & Apps Script
Avatar for Katarina Dahlin katarinadahlin
PRO
1
690
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
Avatar for Sam Stephenson sstephenson
162
16k
Unlocking the hidden potential of vector embeddings in international SEO
Avatar for Frank van Dijk frankvandijk
0
870
End of SEO as We Know It (SMX Advanced Version)
Avatar for Michael King ipullrank
3
4.3k
Scaling GitHub
Avatar for Zach Holman holman
464
140k

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