Overriding defaults for postgresql

[Zoltan Boszormenyi]

Scot L. Harris írta:
> On Sat, 2004-06-12 at 05:35, Colin Paul Adams wrote:
> 
>>What is the recommended way of overriding default options fro
>>postgresql?
>>I want to enable the use of tcp connections, and also to change the
>>default port.
> 
> 
> Unless it has changed from RH8 days you want to look in the
> /var/lib/pgsql/data directory for pg_hba.conf and postgresql.conf.  The
> pg_hba.conf will let you specify who and how people are authenticated. 
> The conf file has some other options you can set.  
> 
> Hope this helps.
> 

... and if you specify "ident" as authentication method in pg_hba.conf,
you must setup pg_ident.conf as well.

You'd better do this as user "postgres", e.g. "su -" to root and
then "su - postgres". The files under /var/lib/pgsql/data must be
owned by user "postgres" and this UID does not have a valid password.