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
130

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
42
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
130
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
89
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
180
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
73
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
320
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
87
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
340

Other Decks in Technology

See All in Technology
Cursorを全エンジニアに配布 その先に見据えるAI駆動開発の未来 / 2025-05-13-forkwell-ai-study-1-cursor-at-loglass
Avatar for Hiroshi Ito itohiro73
2
690
計装を見直してアプリケーションパフォーマンスを改善させた話
Avatar for Kazuki Obata donkomura
2
170
The PyArrow revolution in Pandas
Avatar for Reuven M. Lerner reuven
0
120
事業と組織から目を逸らずに技術でリードする
Avatar for ogugu ogugu9
19
5k
kernelvm-brain-net
Avatar for らすぴー raspython3
0
650
Azure & DevSecOps
Avatar for KAMEGAWA Kazushi kkamegawa
2
200
Terraform にコントリビュートしていたら Azure のコストをやらかした話 / How I Messed Up Azure Costs While Contributing to Terraform
Avatar for ののし nnstt1
1
560
dbtとリバースETLでデータ連携の複雑さに立ち向かう
Avatar for Toru Morooka morookacube
0
1k
チェックツールを導入したけど使ってもらえなかった話 #GAADjp
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
100
非root化Androidスマホでも動く仮想マシンアプリを試してみた
Avatar for Sora Arakawa arkw
0
130
Coding Agentに値札を付けろ
Avatar for watany watany
3
570
問 1：以下のコンパイラを証明せよ（予告編） #kernelvm / Kernel VM Study Kansai 11th
Avatar for y_taka_23 ytaka23
3
620

Featured

See All Featured
The Cost Of JavaScript in 2023
Avatar for Addy Osmani addyosmani
49
7.8k
How to Think Like a Performance Engineer
Avatar for Harry Roberts csswizardry
23
1.6k
Practical Tips for Bootstrapping Information Extraction Pipelines
Avatar for Matthew Honnibal honnibal
PRO
19
1.2k
GraphQLとの向き合い方2022年版
Avatar for Yosuke Kurami quramy
46
14k
Designing for Performance
Avatar for Lara Hogan lara
608
69k
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
14
1.5k
Navigating Team Friction
Avatar for Lara Hogan lara
185
15k
Building a Modern Day 
E-commerce SEO Strategy
Avatar for Aleyda Solis aleyda
40
7.3k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
172
14k
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
271
27k
Embracing the Ebb and Flow
Avatar for Simon Collison colly
85
4.7k
The Psychology of Web Performance [Beyond Tellerrand 2023]
Avatar for Tammy Everts tammyeverts
47
2.7k

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