Thanks Christopher. 

I have found out my postgresql configuration file does run in different
place. Since I am running Enterprise DB plus standard install using
one-click setup method, I don't have to configurate much of things, it's
pretty much all done for me. but on this machine I have trouble with, its
pointing configuration file that's under var/lib/pgsql/data/..... 

Does anybody know why? Is that something I modified that does it? 

How can I change back to where its supposed to be
(/opt/PostgresPlus/8.3/data) ?

contactdb=# show config_file;
             config_file
-------------------------------------
 /var/lib/pgsql/data/postgresql.conf
(1 row)

contactdb=# show hba_file;
            hba_file
---------------------------------
 /var/lib/pgsql/data/pg_hba.conf
(1 row)

contactdb=#


Christopher Browne wrote:
> 
> 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"
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 

-- 
View this message in context: http://www.nabble.com/-Quick-question--Slony-configuration-on-postgresql.conf-and-pg_hba.conf-tp24599592p24619567.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.