roctaiwan <nettreeinc at gmail.com> writes:
> I know we all required to configurate the postgresql.conf and pg_hba.conf for
> linux to work properly with Slony. But I found that each of the conf files
> located at three different places.... which conf should be configurated, all
> three? is this same as any other system that has slony and postgresql?
>
>
> [root at Slave-DB1-Slony-I ~]# find / -name postgresql.conf
> /usr/local/pgsql/data/postgresql.conf
> /var/lib/pgsql/data/postgresql.conf
> /opt/PostgresPlus/8.3/data/postgresql.conf
> [root at Slave-DB1-Slony-I ~]#
> [root at Slave-DB1-Slony-I ~]# find / -name pg_hba.conf
> /usr/local/pgsql/data/pg_hba.conf
> /var/lib/pgsql/pg_hba.conf
> /var/lib/pgsql/data/pg_hba.conf
> /opt/PostgresPlus/8.3/data/pg_hba.conf
> [root at Slave-DB1-Slony-I ~]#

Evidently your Linux distribution does its own thing, several times!

I'd suggest checking with the running database; the following "show"
commands will tell you where *it* thinks its config files are.

mydb=# show hba_file;
                       hba_file
-------------------------------------------------------
 /mnt/PostgreSQL/dbs/PG84/postgresql-8.4.0/pg_hba.conf
(1 row)

mydb=# show config_file;
                        config_file
-----------------------------------------------------------
 /mnt/PostgreSQL/dbs/PG84/postgresql-8.4.0/postgresql.conf
(1 row)

That's what *I* would edit on my system :-).
-- 
output = ("cbbrowne" "@" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"