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

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
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
オントロジーって 結局なにもの？ AI エージェントに「意味」を渡す知識設計の話
Avatar for TomoyukiMurakami greenmidori
0
250
サブエージェントと Claude Mods で作る独自 Advisor ツールの話
Avatar for Kenichi Odo kenichiodo
2
180
Classmethod Company Deck
Avatar for Satoshi7 satoshi7
1
790
Conditional PED-ANOVA: Hyperparameter Importance in Hierarchical & Dynamic Search Spaces
Avatar for Preferred Networks pfn
PRO
0
150
freeeにおけるSoftware Factory
Avatar for freee freee
PRO
0
240
LLM Content Moderationを支える評価・改善ループの実践
Avatar for suikabar suikabar
1
260
小規模OSSモデルは サイバーセキュリティ業務に どこまで使えるか
Avatar for isao takaesu bbrbbq
0
140
20年間 SNS サービス「GREE」 を支えた技術の刷新と、長期運用サービスの Kubernetes へのリアーキテクト
Avatar for gree_tech gree_tech
PRO
0
100
会社紹介資料 / Sansan Company Profile
Avatar for Sansan, Inc. sansan33
PRO
31
430k
AIにシークレットを見せない、WSL2で安全な開発環境
Avatar for yazm4 yazm
0
330
「エーアイ」をバズワードにしないために RPA 導入経験と Kiro 上での Claude モデル利用経験から
Avatar for kazzpapa3 kazzpapa3
0
110
トークン化預金DCJPYの取り組みと活用ユースケース
Avatar for フィンテック養成コミュニティ finengine
0
200

Featured

See All Featured
What does AI have to do with Human Rights?
Avatar for Per Axbom axbom
PRO
1
2.5k
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
348
41k
Ethics towards AI in product and experience design
Avatar for Skipper Chong Warson skipperchong
2
440
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k
Documentation Writing (for coders)
Avatar for Carmen Chung carmenintech
77
5.6k
ReactJS: Keep Simple. Everything can be a component!
Avatar for Pedro Nauck pedronauck
666
130k
Public Speaking Without Barfing On Your Shoes - THAT 2023
Avatar for David Neal reverentgeek
1
600
Learning to Love Humans: Emotional Interface Design
Avatar for Aarron Walter aarron
275
41k
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
560
Code Review Best Practice
Avatar for Trisha Gee trishagee
74
20k
技術選定の審美眼（2025年版） / Understanding the Spiral of Technologies 2025 edition
Avatar for Takuto WADA twada
PRO
120
120k
WENDY [Excerpt]
Avatar for Tessa Abrams tessaabrams
14
40k

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