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

PGCasts 02 - Controlando acessos

6f3efd5477238ca18957c723854ec795?s=47 Sebastian Webber
July 11, 2016
Technology
0
120

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

6f3efd5477238ca18957c723854ec795?s=128

Sebastian Webber

July 11, 2016
Tweet

More Decks by Sebastian Webber

See All by Sebastian Webber
12+ factor databases
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
5
Tests for dummies
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
88
Prometheus 101
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
23
Monitorando seu banco na nuvem
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
110
Monitorando sistemas distribuidos
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
1
40
SRE for Dummies
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
200
Prometheus_Dojo.pdf
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
35
Como ser um DBA na era DEVOPS?
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
190
Pareamento "CrossCompany"
6f3efd5477238ca18957c723854ec795?s=48 sebastianwebber
0
33

Other Decks in Technology

See All in Technology
【SAP知らない人向け】SAP on AWS 個人学習メモ/sap-on-aws-study
97b3cca999b52cb5296675ac0a5c12cd?s=48 emiki
3
2.4k
EKSの運用あれこれ　バージョンアップ編
B379fea91de26a078727b50e89c91b60?s=48 tetsunosato
0
110
さいきんのRaspberry Pi。 / osc22do-rpi
74476e142a767a018d68c5e72e34ee2f?s=48 akkiesoft
6
5.3k
【Pythonデータ分析勉強会#33】「DearPyGuiに入門しました」の続き～Image-Processing-Node-Editor～
26afa82334d1037f0ba602272b950c90?s=48 kazuhitotakahashi
0
190
【配布資料】複数データソースのデータを仮想化してまとめて分析してみよう（AWS、IBM Cloud）
2668e9c14d6673b27f4b8fb809f4fc4b?s=48 tkhresk
0
100
What's new in Vision
53e2d354b3299d64a54af680865516d5?s=48 satotakeshi
0
220
The Fractal Geometry of Software Design
B90ab53ba7cf16ed1a4bb679cc6751d7?s=48 vladikk
1
1.3k
インフラのCI/CDはGitHub Actionsに任せた
F5c597c41d9bc6a80cce50adbd6c7bd9?s=48 mihyon
0
120
Strategyパターン
65389cd2b6fdc531dcc4af999e864593?s=48 hankehly
0
160
HoloLens2とMetaQuest2どちらも動くWebXRアプリをBabylon.jsで作る
Bf0e54ea0d4ea19343ccfbe5d410a96b?s=48 iwaken71
0
210
JAWS-UG re:Habilitaion 報告 / JAWS-UG OITA rehabilitation
5acaf9241f1c2e50f3bff920050ae597?s=48 hiranofumio
0
130
What's Data Lake ? Azure Data Lake best practice
0d7a3b61c5c1f64a50136cf4bb5702b7?s=48 ryomaru0825
2
760

Featured

See All Featured
Statistics for Hackers
56c4053438af8e8b90d6f53cbb7573be?s=48 jakevdp
781
210k
A Modern Web Designer's Workflow
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
689
180k
Building an army of robots
5f2da528927a2ec9ba4fec2069cbc958?s=48 kneath
299
40k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
39
13k
Designing Dashboards & Data Visualisations in Web Apps
Fde6c3a50ca518a909ef35c22c0ee0e4?s=48 destraynor
224
49k
Building Flexible Design Systems
91cefdf141106fa10674aae74ce05890?s=48 yeseniaperezcruz
310
34k
Optimizing for Happiness
25c7c18223fb42a4c6ae1c8db6f50f9b?s=48 mojombo
365
63k
Designing with Data
F57e2136eb9895eb95ff5dc8a1c02677?s=48 zakiwarfel
91
3.9k
GraphQLの誤解/rethinking-graphql
3cb4e761dbdb7aebd1ffd85f752e1e3e?s=48 sonatard
28
6.6k
The Illustrated Children's Guide to Kubernetes
0438ae60cde4c7add6f9da48f28c15cc?s=48 chrisshort
15
36k
Put a Button on it: Removing Barriers to Going Fast.
Bfd6b681ec6e8c9bef82ff0521c364f7?s=48 kastner
56
2.3k
Thoughts on Productivity
A16eb159db895e3b01d3dc95767ad595?s=48 jonyablonski
43
2.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