Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

PGCasts 02 - Controlando acessos

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
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
260
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
110
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
180
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
160
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
250
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
110
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
390
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
150
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
430

Other Decks in Technology

See All in Technology
OpenSharing について熱く語る 〜AI アセットの共有について〜
Avatar for camay kameitomohiro
0
240
MCPゲートウェイを作って運用してわかったこと — Agent時代の権限管理の現在地
Avatar for k.muguruma mtpooh
10
3.2k
SDDの運用にめげずに向き合った話
Avatar for SansanTech sansantech
PRO
1
140
分析の民主化を支えるメタデータ整備の実践
Avatar for KAKEHASHI kakehashi
PRO
4
1.1k
今こそ知りたいAmplifyGen2
Avatar for k.masachika mkdev10
2
160
SREでアラート疲れを 解決しよう！
Avatar for KairiM kairim0
1
220
生成AIと進める探索的データ分析（2026.10.03 第122回Tokyo.R勉強会）
Avatar for tatamiya tatamiya
2
1.4k
The seven pitfalls of AI (revised version)
Avatar for Uwe Friedrichsen ufried
0
300
二歩目のフロントエンド・ウェブアクセシビリティ
Avatar for KAMIHARA Takumi camiha
2
240
V8のArray.prototype.flatを最大約20倍速くするまでと、巨大OSSへの大規模コミットの道のり
Avatar for Riya Amemiya riyaamemiya
0
100
"優秀な誰か"の下位互換にならないために
Avatar for Yuto Nagai(Future) yut0naga1_fa
0
490
メルペイ 会計システム概要と歴史
Avatar for mewuto mewuto
0
200

Featured

See All Featured
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
230k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.8k
[RailsConf 2023] Rails as a piece of cake
Avatar for Vladimir Dementyev palkan
59
7.1k
A Soul's Torment
Avatar for Nat Ma seathinner
8
3.7k
Prompt Engineering for Job Search
Avatar for Mfonobong Umondia mfonobong
0
490
How Software Deployment tools have changed in the past 20 years
Avatar for Geshan Manandhar geshan
2
35k
SEOcharity - Dark patterns in SEO and UX: How to avoid them and build a more ethical web
Avatar for Sara Fernández Carmona sarafernandez
0
300
How GitHub (no longer) Works
Avatar for Zach Holman holman
316
150k
The SEO identity crisis: Don't let AI make you average
Avatar for Varn varn
0
580
Done Done
Avatar for chrislema chrislema
187
17k
AI Search:
Where Are We & What Can We Do About It?
Avatar for Aleyda Solis aleyda
0
8.1k
Mozcon NYC 2025: Stop Losing SEO Traffic
Avatar for Sam Torres samtorres
1
570

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