Re: postgres on SuSE 9.1

From: Bernard Clement <bernard(at)info-electronics(dot)com>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Postgres General Milis <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres on SuSE 9.1
Date: 2004-06-09 22:29:12
Message-ID: 200406091829.12450.bernard@info-electronics.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jao 2004-06-09 22:32:58 Postgresql vs. aggregates
Previous Message Andrew Rawnsley 2004-06-09 21:53:12 Re: tablespaces and schemas