Re: Questions on PostGreSQL Authentication mechanism...

From: Richard Huxton <dev(at)archonet(dot)com>
To: dipti shah <shahdipti1980(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Questions on PostGreSQL Authentication mechanism...
Date: 2010-02-01 10:31:21
Message-ID: 4B66AD79.30605@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/02/10 10:24, dipti shah wrote:
> Thanks Richard. those chapters are very useful. I got to know most of
> concepts but didn't find the location of pg_hba.conf file so that I can
> verify it. I have connected to my database using "postgres" user. Could you
> tell me how to open pg_hba.conf file?

It should be with your other configuration files: postgresql.conf,
pg_ident.conf.

Where will depend on how you installed it. If you're on Windows, it's
probably in the main PostgreSQL folder on drive C:

If a package manager on Linux/Unix look in /etc/postgresql/...

If you compiled from source, probably something like
/usr/local/postgresql/data/

It's a text file and you'll need to restart PostgreSQL to pick up your
new settings.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ray joseph 2010-02-01 10:48:08 Re: How to test my new install
Previous Message dipti shah 2010-02-01 10:24:53 Re: Questions on PostGreSQL Authentication mechanism...