[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Overriding defaults for postgresql



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.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]