Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

PGCasts 02 - Controlando acessos

Avatar for Sebastian Webber Sebastian Webber
July 11, 2016
Technology
160
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
260
12+ factor databases
Avatar for Sebastian Webber sebastianwebber
0
120
Tests for dummies
Avatar for Sebastian Webber sebastianwebber
0
180
Prometheus 101
Avatar for Sebastian Webber sebastianwebber
0
170
Monitorando seu banco na nuvem
Avatar for Sebastian Webber sebastianwebber
0
250
Monitorando sistemas distribuidos
Avatar for Sebastian Webber sebastianwebber
1
120
SRE for Dummies
Avatar for Sebastian Webber sebastianwebber
0
400
Prometheus_Dojo.pdf
Avatar for Sebastian Webber sebastianwebber
0
160
Como ser um DBA na era DEVOPS?
Avatar for Sebastian Webber sebastianwebber
0
440

Other Decks in Technology

See All in Technology
生き様としてのSRE
Avatar for Yutaro Sugai hokkai7go
1
150
2拠点SRE活動始めてみた | sogaoh's LT @ ホンマでっかSRE勉強会 #3
Avatar for Hisashi SOGA sogaoh
PRO
0
230
コードレビューをなくして見えたもの
Avatar for henteko henteko
0
110
AI時代のエンジニアの情報発信〜個人の発信を組織の力に変える〜
Avatar for かわまた ryo_kawamata
0
6.8k
キヨさん、67歳。AIコーディングエージェントに挑む
Avatar for コロッケそば happysamurai294
0
140
Deep Data Security 機能解説
Avatar for oracle4engineer oracle4engineer
PRO
3
990
今から始めるAWS環境の暗号移行 - ポスト量子時代に備える
Avatar for sato4mi sato4mi
0
150
Content Mapper APIの応用例～CSS Modules、言語ファイル～
Avatar for uhyo uhyo
2
510
Vibe-to-Spec開発_実践ガイド
Avatar for コロッケそば happysamurai294
0
140
新米を「売り越さない」、Aurora DSQLで作る在庫ゼロ死守の限定ドロップEC
Avatar for Yuuki Yamashita yama3133
0
140
LLMの知識とAIエージェント
Avatar for コロッケそば happysamurai294
0
150
複雑な業務システムを高速でつくるため、チーム全員をつくれる人へ
Avatar for AyaKurabuchi ayakurabuchi
0
120

Featured

See All Featured
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
39
3.5k
16th Malabo Montpellier Forum Presentation
Avatar for AKADEMIYA2063 akademiya2063
PRO
0
440
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
Avatar for soudai sone soudai
PRO
203
77k
Bioeconomy Workshop: Dr. Julius Ecuru, Opportunities for a Bioeconomy in West Africa
Avatar for AKADEMIYA2063 akademiya2063
PRO
1
440
The AI Search Optimization Roadmap by Aleyda Solis
Avatar for Aleyda Solis aleyda
2
6.4k
エンジニアに許された特別な時間の終わり
Avatar for watany watany
109
250k
Learning to Love Humans: Emotional Interface Design
Avatar for Aarron Walter aarron
275
41k
Sam Torres - BigQuery for SEOs
Avatar for Tech SEO Connect techseoconnect
PRO
0
600
Leveraging Curiosity to Care for An Aging Population
Avatar for Cassini Nazir cassininazir
1
550
Documentation Writing (for coders)
Avatar for Carmen Chung carmenintech
77
5.6k
Heart Work Chapter 1 - Part 1
Avatar for Lake Fama lfama
PRO
10
37k
Designing for Timeless Needs
Avatar for Cassini Nazir cassininazir
1
540

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