After a bit more of search, pg_hba.conf seems to be in /var/lib/pgsql/data
under SuSE 9.0.
The following was the steps I used to find the location:
1- Look in /etc/rc.d/postgresql for some clue. It points to /etc/sysconfig/
postgresql
2- Look in /etc/sysconfig/postgresql and another clue is "~postgres/data"
3- Hum! the ~postgres means the home of the user postgres. Look into /etc/
passwd to find the home of the user postgres and it is /var/lib/pgsql
4- Effectively under /var/lib/pgsql there is a directory called data which
contains the file pg_hba.conf.
I am using 9.0 right now but this was true for previous version of SuSE as
well. Therefore, I would assume that that it will be in the smae place in
9.1
Bernard
On Wednesday 09 June 2004 17:11, Bernard Clement wrote:
> It seems that the command locate is not installed by default under SuSE (I
> am using 9.0).
>
> However, that command is in the package "findutils-locate" that comes with
> the distribution. You can install it with Yast.
>
> Bernard
>
> On Wednesday 09 June 2004 16:09, Alvaro Herrera wrote:
> > On Wed, Jun 09, 2004 at 01:48:11PM -0600, Scott Marlowe wrote:
> > > On Wed, 2004-06-09 at 13:09, Prabu Subroto wrote:
> > > > Here is my try under below:
> > > > susefujitsu:~ # whoami
> > > > root
> > > > susefujitsu:~ # locate pg_hba.conf
> > > > bash: locate: command not found
> > > > susefujitsu:~ #
> > >
> > > Dang, then I don't have a clue what to do. Maybe a google search for
> > > pg_hba.conf and suse?
> >
> > What about
> >
> > find / -name pg_hba.conf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster