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
91
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
160
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
140
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
230
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
97
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
400

Other Decks in Technology

See All in Technology
Building applications in the Gemini API family.
Avatar for LINE Developers Taiwan line_developers_tw
PRO
0
1.3k
AIにフローを作らせようとして挫折した話
Avatar for 濱津 太一｜ユースフル hamatsutaichi
0
180
Chart.js が簡単に使えるようになっていたので OGP 画像生成に使った話
Avatar for すずとも kamekyame
0
160
DevOps Agentで始めるAWS運用 〜フロンティアエージェントが変える運用の現場〜
Avatar for nyankotaro nyankotaro
1
210
ルールやカスタム機能、どう使う？理想の出力を引き出すために今知りたいIBM Bob 5つの機能
Avatar for mu (Mizuho Uehara) muehara
1
330
Djangoユーザが知っ得なPostgreSQL機能 - 設計の選択肢を増やす / Djang-use-PostgreSQL
Avatar for soudai sone soudai
PRO
0
180
新アーキテクチャ「TiDB X」解説とDedicated比較 TiDB Cloud Premiumのゲーム運用活用を検証
Avatar for altplus Inc. staffrecruiter
0
110
noUncheckedIndexedAccess、3時間、1万円。 / noUncheckedIndexedAccess, 3 Hours, 10,000 JPY.
Avatar for 株式会社カオナビ kaonavi
1
290
Dynamic Workersについて
Avatar for Yusuke Wada yusukebe
2
580
Databricks 月刊サービスアップデート 2026年05月号
Avatar for ちょし tyosi1212
0
210
【５分でわかる】セーフィー エンジニア向け会社紹介
Avatar for Safie safie_recruit
0
50k
Claude Codeを組織で使いこなす— サーバサイドAIエージェント運用の実践知
Avatar for PERSOL CAREER Dev | techtekt techtekt
PRO
0
200

Featured

See All Featured
[RailsConf 2023 Opening Keynote] The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
31
10k
Git: the NoSQL Database
Avatar for Brandon Keepers bkeepers
PRO
432
67k
Digital Ethics as a Driver of Design Innovation
Avatar for Per Axbom axbom
PRO
1
300
How to build a perfect <img>
Avatar for Jono Alderson jonoalderson
1
5.6k
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
Avatar for Tech SEO Connect techseoconnect
PRO
0
190
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
Avatar for Liv Day livdayseo
0
130
BBQ
Avatar for Matthew Crist matthewcrist
89
10k
Embracing the Ebb and Flow
Avatar for Simon Collison colly
88
5.1k
Keith and Marios Guide to Fast Websites
Avatar for Keith Pitt keithpitt
413
23k
How Software Deployment tools have changed in the past 20 years
Avatar for Geshan Manandhar geshan
0
34k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.6k
A Soul's Torment
Avatar for Nat Ma seathinner
6
2.9k

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