$30 off During Our Annual Pro Sale. View Details »

PGCasts 02 - Controlando acessos

Avatar for Sebastian Webber Sebastian Webber
July 11, 2016
Technology
0
140

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

Avatar for Sebastian Webber

Sebastian Webber

July 11, 2016
Tweet

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
220
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
66
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
150
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
110
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
200
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
86
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
350
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
110
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
380

Other Decks in Technology

See All in Technology
[Neurogica] 採用ポジション/ Recruitment Position
Avatar for Neurogica neurogica
1
130
『君の名は』と聞く君の名は。 / Your name, you who asks for mine.
Avatar for NTT docomo Business nttcom
1
120
AgentCore BrowserとClaude Codeスキルを活用した 『初手AI』を実現する業務自動化AIエージェント基盤
Avatar for Hirokatsu Endo ruzia
7
1.5k
AWS re:Invent 2025~初参加の成果と学び~
Avatar for Kubo kubomasataka
0
190
たまに起きる外部サービスの障害に備えたり備えなかったりする話
Avatar for Sohei Iwahori egmc
0
410
「図面」から「法則」へ 〜メタ視点で読み解く現代のソフトウェアアーキテクチャ〜
Avatar for Satoshi Kobayashi scova0731
0
500
20251222_サンフランシスコサバイバル術
Avatar for ponponmikan ponponmikankan
2
140
Bedrock AgentCore Evaluationsで学ぶLLM as a judge入門
Avatar for ShichijoYuhi shichijoyuhi
2
250
AIBuildersDay_track_A_iidaxs
Avatar for iidaxs iidaxs
4
1.3k
MySQLのSpatial(GIS)機能をもっと充実させたい ～ MyNA望年会2025LT
Avatar for sakaik sakaik
0
120
日本の AI 開発と世界の潮流 / GenAI Development in Japan
Avatar for Yoshitaka Haribara hariby
1
470
AR Guitar: Expanding Guitar Performance from a Live House to Urban Space
Avatar for Ekito ekito_station
0
220

Featured

See All Featured
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
0
310
[SF Ruby Conf 2025] Rails X
Avatar for Vladimir Dementyev palkan
0
600
Money Talks: Using Revenue to Get Sh*t Done
Avatar for Nikki Halliwell nikkihalliwell
0
120
Bridging the Design Gap: How Collaborative Modelling removes blockers to flow between stakeholders and teams @FastFlow conf
Avatar for Kenny Baas-Schwegler baasie
0
410
SEO in 2025: How to Prepare for the Future of Search
Avatar for Michael King ipullrank
3
3.3k
Paper Plane
Avatar for Katie Cordina Lindsey katiecoart
PRO
0
44k
GitHub's CSS Performance
Avatar for Jon Rohan jonrohan
1032
470k
First, design no harm
Avatar for Per Axbom axbom
PRO
1
1.1k
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
32
2.8k
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
141
7.3k
What does AI have to do with Human Rights?
Avatar for Per Axbom axbom
PRO
0
1.9k
Helping Users Find Their Own Way: Creating Modern Search Experiences
Avatar for Dan Newman danielanewman
31
3k

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