The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Liberar postgresql para Acesso remoto

Discussion in 'Discussões em Português' started by robsonwr, Jun 19, 2012.

  1. robsonwr

    robsonwr Member

    Joined:
    Jun 21, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Piracicaba - BR
    cPanel Access Level:
    DataCenter Provider
    Bom dia amigos

    no mysql para liberar para acesso remoto colocamos %

    e no postgresql como fazer ?

    versao postgresql 8.1 a padrão do cpanel
     
  2. tuxinside

    tuxinside Registered

    Joined:
    Jan 25, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Boas,

    Para resolveres esse problema, segue os seguintes passos:

    1. Fazer login por SSH ao servidor:
    $ ssh user@remote.pgsql.server.com

    2. Editar o ficheiro:
    $ vi /var/lib/pgsql/data/pg_hba.conf
    OU
    $ vi /etc/postgresql/8.2/main/pg_hba.conf

    3. Adicionar ao ficheiro a seguinte linha
    host all all 10.10.29.0/24 trust

    Espero que tenha ajudado.
     
Loading...
Similar Threads - Liberar postgresql para
  1. Eli Junior
    Replies:
    7
    Views:
    1,105

Share This Page