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

Other Decks in Technology

See All in Technology
OpenJDKエコシステムと開発中の機能を紹介 2025夏版
Avatar for Chihiro Ito chiroito
1
1.1k
Go Connectへの想い
Avatar for chiroruxx chiroruxx
0
150
Digitization部 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
4k
Agent Development Kit によるエージェント開発入門
Avatar for Etsuji Nakai enakai00
18
2.7k
Tensix Core アーキテクチャ解説
Avatar for Tenstorrent Japan tenstorrent_japan
0
230
Drawing with LLMs
Avatar for Rist Inc. rist
0
230
Data Hubグループ 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
1.8k
Spring for GraphQLって実際どうなの？〜小規模スタートアップの事例紹介〜
Avatar for koga yushi kogayushi
0
160
impressions-trying-lambda-web-adapter
Avatar for Junki Ishigaki junkishigaki
2
140
Eight Engineering Unit 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
3.4k
OpenTelemetry Collector internals
Avatar for ymotongpoo ymotongpoo
3
200
ゆるSRE #11 LT
Avatar for Kaoru okaru
1
370

Featured

See All Featured
Building a Modern Day 
E-commerce SEO Strategy
Avatar for Aleyda Solis aleyda
41
7.3k
Large-scale JavaScript Application Architecture
Avatar for Addy Osmani addyosmani
512
110k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
248
1.3M
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.3k
Gamification - CAS2011
Avatar for David Bonilla davidbonilla
81
5.3k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
Avatar for Eileen M. Uchitelle eileencodes
137
34k
Reflections from 52 weeks, 52 projects
Avatar for Jefferson Lam jeffersonlam
349
20k
Making Projects Easy
Avatar for Brett Harned brettharned
116
6.2k
Fireside Chat
Avatar for paigeccino paigeccino
37
3.5k
4 Signs Your Business is Dying
Avatar for Josh Pigford shpigford
183
22k
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
790
250k
BBQ
Avatar for Matthew Crist matthewcrist
89
9.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