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
190
12+ factor databases
sebastianwebber
0
23
Tests for dummies
sebastianwebber
0
110
Prometheus 101
sebastianwebber
0
54
Monitorando seu banco na nuvem
sebastianwebber
0
150
Monitorando sistemas distribuidos
sebastianwebber
1
59
SRE for Dummies
sebastianwebber
0
290
Prometheus_Dojo.pdf
sebastianwebber
0
75
Como ser um DBA na era DEVOPS?
sebastianwebber
0
310
Other Decks in Technology
See All in Technology
Oracle Cloud Infrastructureデータベース・クラウド:各バージョンのサポート期間
oracle4engineer
PRO
28
13k
DynamoDB でスロットリングが発生したとき/when_throttling_occurs_in_dynamodb_short
emiki
0
250
ドメインの本質を掴む / Get the essence of the domain
sinsoku
2
160
AWS Media Services 最新サービスアップデート 2024
eijikominami
0
200
B2B SaaSから見た最近のC#/.NETの進化
sansantech
PRO
0
890
強いチームと開発生産性
onk
PRO
35
11k
OS 標準のデザインシステムを超えて - より柔軟な Flutter テーマ管理 | FlutterKaigi 2024
ronnnnn
0
200
100 名超が参加した日経グループ横断の競技型 AWS 学習イベント「Nikkei Group AWS GameDay」の紹介/mediajaws202411
nikkei_engineer_recruiting
1
170
Python(PYNQ)がテーマのAMD主催のFPGAコンテストに参加してきた
iotengineer22
0
500
エンジニア人生の拡張性を高める 「探索型キャリア設計」の提案
tenshoku_draft
1
130
SRE×AIOpsを始めよう!GuardDutyによるお手軽脅威検出
amixedcolor
0
170
BLADE: An Attempt to Automate Penetration Testing Using Autonomous AI Agents
bbrbbq
0
320
Featured
See All Featured
Building a Modern Day E-commerce SEO Strategy
aleyda
38
6.9k
What's new in Ruby 2.0
geeforr
343
31k
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
8
900
Optimising Largest Contentful Paint
csswizardry
33
2.9k
Done Done
chrislema
181
16k
Agile that works and the tools we love
rasmusluckow
327
21k
Building a Scalable Design System with Sketch
lauravandoore
459
33k
A Philosophy of Restraint
colly
203
16k
Fantastic passwords and where to find them - at NoRuKo
philnash
50
2.9k
A Tale of Four Properties
chriscoyier
156
23k
Mobile First: as difficult as doing things right
swwweet
222
8.9k
Learning to Love Humans: Emotional Interface Design
aarron
273
40k
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