Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
PGCasts 02 - Controlando acessos
Search
Sebastian Webber
July 11, 2016
Technology
0
130
PGCasts 02 - Controlando acessos
Controlando acessos ao servidor PostgreSQL
Sebastian Webber
July 11, 2016
Tweet
Share
More Decks by Sebastian Webber
See All by Sebastian Webber
Corrupção de dados: de onde vem? do que se alimenta?
sebastianwebber
0
200
12+ factor databases
sebastianwebber
0
32
Tests for dummies
sebastianwebber
0
120
Prometheus 101
sebastianwebber
0
77
Monitorando seu banco na nuvem
sebastianwebber
0
170
Monitorando sistemas distribuidos
sebastianwebber
1
66
SRE for Dummies
sebastianwebber
0
310
Prometheus_Dojo.pdf
sebastianwebber
0
81
Como ser um DBA na era DEVOPS?
sebastianwebber
0
330
Other Decks in Technology
See All in Technology
株式会社Awarefy(アウェアファイ)会社説明資料 / Awarefy-Company-Deck
awarefy
3
12k
【内製開発Summit 2025】イオンスマートテクノロジーの内製化組織の作り方/In-house-development-summit-AST
aeonpeople
2
1.1k
30→150人のエンジニア組織拡大に伴うアジャイル文化を醸成する役割と取り組みの変化
nagata03
0
350
LayerXにおけるAI活用事例とその裏側(2025年2月) バクラクの目指す “業務の自動運転” の例 / layerx-ai-deim2025
yuya4
1
540
DevinでAI AWSエンジニア製造計画 序章 〜CDKを添えて〜/devin-load-to-aws-engineer
tomoki10
0
210
AIエージェント開発のノウハウと課題
pharma_x_tech
9
4.8k
プロダクト開発者目線での Entra ID 活用
sansantech
PRO
0
120
MIMEと文字コードの闇
hirachan
2
1.5k
IoTシステム開発の複雑さを低減するための統合的アーキテクチャ
kentaro
1
130
【5分でわかる】セーフィー エンジニア向け会社紹介
safie_recruit
0
19k
MLflowはどのようにLLMOpsの課題を解決するのか
taka_aki
0
130
困難を「一般解」で解く
fujiwara3
7
2.2k
Featured
See All Featured
Six Lessons from altMBA
skipperchong
27
3.6k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
45
9.4k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
6
580
Bash Introduction
62gerente
611
210k
Optimizing for Happiness
mojombo
377
70k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
330
21k
Typedesign – Prime Four
hannesfritz
41
2.5k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
115
51k
Product Roadmaps are Hard
iamctodd
PRO
51
11k
Designing Experiences People Love
moore
140
23k
Facilitating Awesome Meetings
lara
53
6.3k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
Transcript
PostgreSQL Screencasts 02
• CEntOS 7.X • PostgreSQL 9.5 • http://bit.ly/pgcast_ vagrant
'*' • 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
Situação antes do primeiro acesso.
Situação após o primeiro acesso.
• https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html • Faça reload no banco de dados pra
aplicar as mudanças
# firewall-cmd --get-active-zones # firewall-cmd --zone=public --add-port=5432/tcp -–permanent # firewall-cmd
--reloadsuccess
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