Wed Jul 22 22:41:29 PDT 2009
- Previous message: [Slony1-general] [Quick question] Slony configuration on postgresql.conf and pg_hba.conf
- Next message: [Slony1-general] slon engine pointing to the wrong directory
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] [Quick question] Slony configuration on postgresql.conf and pg_hba.conf
- Next message: [Slony1-general] slon engine pointing to the wrong directory
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list