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
180
12+ factor databases
sebastianwebber
0
18
Tests for dummies
sebastianwebber
0
110
Prometheus 101
sebastianwebber
0
51
Monitorando seu banco na nuvem
sebastianwebber
0
140
Monitorando sistemas distribuidos
sebastianwebber
1
56
SRE for Dummies
sebastianwebber
0
280
Prometheus_Dojo.pdf
sebastianwebber
0
67
Como ser um DBA na era DEVOPS?
sebastianwebber
0
300
Other Decks in Technology
See All in Technology
クラウド利用者の「責任」をどう果たす?AWSセキュリティ対策のススメ #AWSSummit
hiashisan
0
280
成長期に歩みを止めないための創業期の開発文化形成
mayah
6
420
RAGのサービスをリリースして1年3ヶ月が経ちました
segavvy
4
960
大規模ドラレコデータ収集・機械学習基盤を支える AWS CDK 〜導入・運用事例紹介〜
pemugi
0
110
コンテナ・K8s研修 - 前半 コンテナ基礎・ハンズオン【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
170
技術負債による事業の失敗はなぜ起こるのか / Why do business failures due to technical debt occur?
i35_267
0
190
[I/O Extended Android 2024] What`s new in Android 2024
kyeongwan
0
220
20240724_cm_odyssey_hibiyatech
hiashisan
0
110
VPoEの視点から見た、ヘンリーがサーバーサイドKotlinを使う理由 / Why Server-side Kotlin 2024
cho0o0
1
420
プレイドにおけるDatadog APMの活用方法
plaidtech
PRO
2
120
MySQLのロックの種類とその競合
yoku0825
6
1.6k
さらに高品質・高速化を目指すAI時代のテスト設計支援と、めざす先 / AI Test Lab vol.1
shift_evolve
0
190
Featured
See All Featured
Visualization
eitanlees
139
14k
The Invisible Customer
myddelton
117
13k
The Power of CSS Pseudo Elements
geoffreycrofte
64
5.2k
Optimising Largest Contentful Paint
csswizardry
18
2.6k
Faster Mobile Websites
deanohume
303
30k
How to name files
jennybc
67
96k
Building a Scalable Design System with Sketch
lauravandoore
458
32k
Teambox: Starting and Learning
jrom
130
8.6k
Thoughts on Productivity
jonyablonski
64
4.1k
For a Future-Friendly Web
brad_frost
173
9.2k
Statistics for Hackers
jakevdp
792
220k
Code Reviewing Like a Champion
maltzj
517
39k
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