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
52
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
140
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
100
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
190
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
81
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
340
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
97
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
360

Other Decks in Technology

See All in Technology
Cloud WANの基礎から応用～少しだけDeep Dive～
Avatar for モブエンジニア（Masaki Okuda） masakiokuda
3
120
JAWS AI/ML #30 AI コーディング IDE "Kiro" を触ってみよう
Avatar for Riku INADA inariku
3
400
datadog-distribution-of-opentelemetry-collector-intro
Avatar for tetsuya28 tetsuya28
0
120
Exadata Database Service on Dedicated Infrastructure セキュリティ、ネットワーク、および管理について
Avatar for oracle4engineer oracle4engineer
PRO
1
330
Foundation Model × VisionKit で実現するローカル OCR
Avatar for SansanTech sansantech
PRO
1
420
AIに頼りすぎない新人育成術
Avatar for CUEBiC Inc. cuebic9bic
3
330
2025新卒研修・Webアプリケーションセキュリティ #弁護士ドットコム
Avatar for 弁護士ドットコム bengo4com
3
9.4k
Kiro と Q Dev で 同じゲームを作らせてみた
Avatar for r3_yamauchi r3_yamauchi
PRO
1
120
歴代のWeb Speed Hackathonの出題から考えるデグレしないパフォーマンス改善
Avatar for did0es shuta13
6
520
20250818_KGX・One Hokkaidoコラボイベント
Avatar for tohge05 tohgeyukihiro
0
110
なごミュ@SPAJAM2025 第二回予選
Avatar for drama 1901drama
0
110
リモートワークで心掛けていること 〜AI活用編〜
Avatar for naoki85 naoki85
0
190

Featured

See All Featured
Easily Structure & Communicate Ideas using Wireframe
Avatar for Afnizar Nur Ghifari afnizarnur
194
16k
Testing 201, or: Great Expectations
Avatar for Joseph Mastey jmmastey
45
7.6k
10 Git Anti Patterns You Should be Aware of
Avatar for Lemi Orhan Ergin lemiorhan
PRO
656
60k
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
5.7k
Rails Girls Zürich Keynote
Avatar for Gregor Martynus gr2m
95
14k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
Avatar for Eileen M. Uchitelle eileencodes
139
34k
ReactJS: Keep Simple. Everything can be a component!
Avatar for Pedro Nauck pedronauck
667
120k
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
90
590k
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
407
66k
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
37
2.8k
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
272
27k
Save Time (by Creating Custom Rails Generators)
Avatar for Garrett Dimon garrettdimon
PRO
32
1.4k

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