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

PGCasts 02 - Controlando acessos

Sebastian Webber
July 11, 2016
Technology
0
120

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

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?
sebastianwebber
0
77
12+ factor databases
sebastianwebber
0
7
Tests for dummies
sebastianwebber
0
95
Prometheus 101
sebastianwebber
0
29
Monitorando seu banco na nuvem
sebastianwebber
0
120
Monitorando sistemas distribuidos
sebastianwebber
1
43
SRE for Dummies
sebastianwebber
0
230
Prometheus_Dojo.pdf
sebastianwebber
0
36
Como ser um DBA na era DEVOPS?
sebastianwebber
0
230

Other Decks in Technology

See All in Technology
Airdrop for Open Source Projects
epicsdao
0
350
230120 ガンダムの事例にみる自動化の対象 Haruka Oh!さん
comucal
PRO
0
120
2年で10→70人へ！ スタートアップの 情報セキュリティ課題と施策
miekobayashi
1
210
AI Builderについて
miyakemito
0
780
ラズパイとGASで加湿器の消し忘れをLINEでリマインド＆操作
minako__ph
0
130
GitHub Codespaces が拡げる開発環境、いつでもどこでも Visual Studio Code で！
dzeyelid
0
160
データベースの発表には RDBMS 以外もありますよ
maroon1st
0
230
私見「UNIXの考え方」/20230124-kameda-unix-phylosophy
opelab
0
160
DNS権威サーバのクラウドサービス向けに行われた攻撃および対策 / DNS Pseudo-Random Subdomain Attack and mitigations
kazeburo
5
1.2k
日本ディープラーニング協会主催 NeurIPS 2022 技術報告会講演資料
tdailab
0
1k
Dev Containers ことはじめ - 失敗から学ぶ開発環境運用法
streamwest1629
0
290
2022年に起きたフロントエンドの変化
sakito
29
17k

Featured

See All Featured
Learning to Love Humans: Emotional Interface Design
aarron
263
38k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
351
21k
Six Lessons from altMBA
skipperchong
15
2.3k
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
reverentgeek
175
9.1k
Side Projects
sachag
451
37k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
38
3.6k
Building a Scalable Design System with Sketch
lauravandoore
451
31k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
226
16k
Practical Orchestrator
shlominoach
178
8.9k
Building Better People: How to give real-time feedback that sticks.
wjessup
346
17k
YesSQL, Process and Tooling at Scale
rocio
159
12k
The Power of CSS Pseudo Elements
geoffreycrofte
52
4.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