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

PGCasts 02 - Controlando acessos

PGCasts 02 - Controlando acessos

Controlando acessos ao servidor PostgreSQL

Sebastian Webber

July 11, 2016
Tweet

More Decks by Sebastian Webber

Other Decks in Technology

Transcript

  1. PostgreSQL Screencasts 02

    View Slide

  2. • CEntOS 7.X
    • PostgreSQL 9.5
    • http://bit.ly/pgcast_
    vagrant

    View Slide

  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

    View Slide

  4. Situação antes do primeiro acesso.

    View Slide

  5. Situação após o primeiro acesso.

    View Slide

  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

    View Slide

  7. # firewall-cmd --get-active-zones
    # firewall-cmd --zone=public --add-port=5432/tcp -–permanent
    # firewall-cmd --reloadsuccess

    View Slide

  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

    View Slide