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
140
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
210
12+ factor databases
sebastianwebber
0
44
Tests for dummies
sebastianwebber
0
130
Prometheus 101
sebastianwebber
0
92
Monitorando seu banco na nuvem
sebastianwebber
0
180
Monitorando sistemas distribuidos
sebastianwebber
1
75
SRE for Dummies
sebastianwebber
0
330
Prometheus_Dojo.pdf
sebastianwebber
0
89
Como ser um DBA na era DEVOPS?
sebastianwebber
0
350
Other Decks in Technology
See All in Technology
OpenJDKエコシステムと開発中の機能を紹介 2025夏版
chiroito
1
1.1k
Go Connectへの想い
chiroruxx
0
150
Digitization部 紹介資料
sansan33
PRO
1
4k
Agent Development Kit によるエージェント開発入門
enakai00
18
2.7k
Tensix Core アーキテクチャ解説
tenstorrent_japan
0
230
Drawing with LLMs
rist
0
230
Data Hubグループ 紹介資料
sansan33
PRO
0
1.8k
Spring for GraphQLって実際どうなの?〜小規模スタートアップの事例紹介〜
kogayushi
0
160
impressions-trying-lambda-web-adapter
junkishigaki
2
140
Eight Engineering Unit 紹介資料
sansan33
PRO
0
3.4k
OpenTelemetry Collector internals
ymotongpoo
3
200
ゆるSRE #11 LT
okaru
1
370
Featured
See All Featured
Building a Modern Day E-commerce SEO Strategy
aleyda
41
7.3k
Large-scale JavaScript Application Architecture
addyosmani
512
110k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
248
1.3M
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.3k
Gamification - CAS2011
davidbonilla
81
5.3k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
137
34k
Reflections from 52 weeks, 52 projects
jeffersonlam
349
20k
Making Projects Easy
brettharned
116
6.2k
Fireside Chat
paigeccino
37
3.5k
4 Signs Your Business is Dying
shpigford
183
22k
How To Stay Up To Date on Web Technology
chriscoyier
790
250k
BBQ
matthewcrist
89
9.7k
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