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.

PostGreSQL - backup problem

Discussion in 'General Discussion' started by reltringham, Sep 15, 2005.

  1. reltringham

    reltringham Member

    Joined:
    Feb 16, 2005
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Auckland, New Zealand
    Hello,

    PostGreSQL was recently installed on our CPanel (10.6.0-R158) server.

    When the backup script (cpbackup) ran, it generated the following error:

    Grabbing PostgreSQL databases............
    psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off
    psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off​

    "[local]" is not a valid entry for a host in pg_hba.conf.

    There have been a recent update to /scripts/cpbackup (on 14 September 2005). This is the first time the backup script would have run since this update, and the first backup since PostGreSQL was installed. (I'm running weekly backups.)

    Is this an error in a script? Any ideas about what I can do to fix it?

    -- Richard.
     
  2. kinsky

    kinsky Well-Known Member

    Joined:
    Jan 28, 2005
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    open file /var/lib/pgsql/data/pg_hba.conf

    add these line below

    local all all md5
    host all all 127.0.0.1 255.255.255.255 md5

    save and quit

    restart by using /scripts/restartsrv_postgres
     
Loading...

Share This Page