Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2017
    Posts
    2

    Unanswered: The pg_hba.conf file is getting reset -- why would this happen?

    I am fairly new to Postgres administration. I have a new 8.4 installation on CentOS. The database is running fine, except that twice now I lose connectivity due to the pg_hba.conf file being reset to what looks like a default copy of the file. I have a backup of my modified pg_hba.conf file so replacing the default file restores my connectivity.

    Is there something in Postgres that would automatically reset the pg_hba.conf file? Restart of the service, a job, something else?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,983
    Provided Answers: 23
    Quote Originally Posted by MasterSchema View Post
    Is there something in Postgres that would automatically reset the pg_hba.conf file?
    No, absolutely not. It must something in your environment.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Mar 2017
    Posts
    2
    Quote Originally Posted by shammat View Post
    No, absolutely not. It must something in your environment.
    Thanks for quick response. Similarly, is there anything that can happen with Postgres that would cause it to reset this file to default? I suspect the answer is no, but I'm confused as to what is happening, because I created and installed everything on this system. Very little exists on it and I put nothing in place that would replace files like this (no cron job, etc.) so I'm stumped as to what is happening. When it happened the first time I ignored it and chalked it up to a peculiarity, but it's happened twice now which means something is happening or a job is running somewhere that is recreating this file...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •