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
150
0

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

Avatar for Sebastian Webber

Sebastian Webber

July 11, 2016

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
250
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
110
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
170
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
160
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
240
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
110
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
390
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
150
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
420

Other Decks in Technology

See All in Technology
AI駆動開発を組織で促すために
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
7
8.8k
MCPを待つな、パスキーを拡げよう（OAuth/OIDC Numa (Immersion) Workshop 2026）
Avatar for OpenID Foundation Japan oidfj
PRO
0
380
Introduction to Bill One Development Engineer
Avatar for Sansan, Inc. sansan33
PRO
0
480
本番に近いテストをもっと手軽に - Postmanで広がるAPIテストの世界 / Expanding the World of API Testing with Postman
Avatar for Yoichi Kawasaki yokawasa
1
160
カーネルまで探検して理解するふたつの自動計装
Avatar for すみや sumiyae
0
340
dbt と Snowflake と tag
Avatar for Kosaku Ono kevinrobot34
2
300
hookで自作する Claude Code の「実況ボード」
Avatar for Shinya Saita shinyasaita
2
240
研究開発部の紹介 / Sansan R&D Profile
Avatar for Sansan, Inc. sansan33
PRO
4
24k
AWSとAzureのマルチクラウド活用における強い味方___AWS_Kiroを使った二刀流スキル作成.pdf
Avatar for k-kun duelist2020jp
1
140
Kiro５兄弟のいまどきのセキュリティ基礎知識
Avatar for Hiroo Katoh kentapapa
0
410
Windows の互換機能 - 古いプログラムはなぜ動作できるのか
Avatar for Murachi Akira murachiakira
PRO
0
130
Oracle AI Databaseデータベース・サービス: BaseDB/ExaDB-Dの可用性
Avatar for oracle4engineer oracle4engineer
PRO
1
980

Featured

See All Featured
Site-Speed That Sticks
Avatar for Harry Roberts csswizardry
13
1.5k
Building AI with AI
Avatar for Ines Montani inesmontani
PRO
1
1.2k
Prompt Engineering for Job Search
Avatar for Mfonobong Umondia mfonobong
0
420
How to Think Like a Performance Engineer
Avatar for Harry Roberts csswizardry
28
2.8k
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
47
8.3k
Efficient Content Optimization with Google Search Console & Apps Script
Avatar for Katarina Dahlin katarinadahlin
PRO
1
820
Done Done
Avatar for chrislema chrislema
186
16k
Public Speaking Without Barfing On Your Shoes - THAT 2023
Avatar for David Neal reverentgeek
1
550
Accessibility Awareness
Avatar for Sarah Abderemane sabderemane
1
190
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
Avatar for Dan Newman danielanewman
230
23k
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
32
3k
So, you think you're a good person
Avatar for Per Axbom axbom
PRO
2
2.1k

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