Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

where is the pg_hba.conf file

where is the pg_hba.conf file

where is the pg_hba.conf file

I am new to Postgresql and am facing problems establishing a PHP-Postgresql connection

I need to know where Redhat 7.3 stores the pg_hba.conf file

Also if someone could explain step by step how to complete this process I would be grateful.Initially I was getting an error saying that the db was not accepting TCP-IP connections on port 5432.

I have changed the /etc/rc.d/init.d/postgresql file to include the -i and -o options on line 151.

Now it is showing an error in the pg_hba.conf file

I have both PHP and Postgresql installed(redhat 7.3), I have made no changes to the default installation

RE: where is the pg_hba.conf file

On a default install of PostgreSQL, the pg_hba.conf file (and postgresql.conf) is usually located at /usr/local/pgsql/data. But RedHat, and many other systems don't always follow the default.

Are you familiar with the Unix "locate" command? In most Linux distributions there is a cron job that regularly indexes all the files on your system, and lets you search for them easily with "locate filename", or even "locate [pattern]". If you want to make sure that index is current, become root and then enter the command "updatedb &". This will update the filesystem index. The & makes it run in the background, and it shouldn't take more than about 5 or 10 minutes.

If for some reason, there is no pg_hba.conf file anywhere on your system, then PostgreSQL just assumes the default settings for pg_hba.conf. All you need to do is create a file by that name, either in /usr/local/pgsql/data, or wherever the postgresql.conf file is located.


Big Brother: "War is Peace" -- Big Business: "Trust is Suspicion"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close