Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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
210
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
46
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
140
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
92
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
180
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
78
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
330
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
91
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
350

Other Decks in Technology

See All in Technology
データ戦略部門 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
3.2k
Kotlinで学ぶ 代数的データ型
Avatar for Kanon ysknsid25
5
1k
開発フェーズだけではない AI導入はどのように進めていくべきか / How should we proceed with AI adoption beyond the development stage?
Avatar for Masato Ishigaki / 石垣雅人 i35_267
2
130
Grafana MCP serverでなんかし隊 / Try Grafana MCP server
Avatar for kohbis kohbis
0
310
AWS全冠したので振りかえってみる
Avatar for tajimon tajimon
0
110
大失敗しないための Web API 開発レシピ / A recipe for not making a big failure on WebAPI development
Avatar for Yoichi Kawasaki yokawasa
1
260
研究開発部メンバーの働き⽅ / Sansan R&D Profile
Avatar for Sansan, Inc. sansan33
PRO
3
17k
OpenTelemetry Collector internals
Avatar for ymotongpoo ymotongpoo
5
510
「どこにある？」の解決。生成AI(RAG)で効率化するガバメントクラウド運用
Avatar for Toru_Kubota toru_kubota
2
270
生成AIをテストプロセスに活用し"よう"としている話 #jasstnano
Avatar for Makky makky_tyuyan
0
100
本部長の代わりに提案書レビュー！ KDDI営業が毎日使うAIエージェント「A-BOSS」開発秘話
Avatar for みのるん minorun365
PRO
10
1.2k
Two-Tower モデルで実現する 検索リランキング / Shibuya_AI_2
Avatar for Visional Engineering ＆ Design visional_engineering_and_design
2
170

Featured

See All Featured
Art, The Web, and Tiny UX
Avatar for Lynn Fisher lynnandtonic
299
21k
Music & Morning Musume
Avatar for Bryan Veloso bryan
46
6.6k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
123
52k
Facilitating Awesome Meetings
Avatar for Lara Hogan lara
54
6.4k
Distributed Sagas: A Protocol for Coordinating Microservices
Avatar for Caitie McCaffrey caitiem20
331
22k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
Avatar for Rebecca Miller-Webster rmw
34
3k
Adopting Sorbet at Scale
Avatar for Ufuk Kayserilioglu ufuk
77
9.4k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
28
3.8k
Gamification - CAS2011
Avatar for David Bonilla davidbonilla
81
5.3k
Practical Tips for Bootstrapping Information Extraction Pipelines
Avatar for Matthew Honnibal honnibal
PRO
20
1.3k
Keith and Marios Guide to Fast Websites
Avatar for Keith Pitt keithpitt
411
22k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
130
19k

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