Le mercredi 22 juillet 2009 à 05:48:09, roctaiwan a écrit : > correction. it seems like my pg_hba.conf are located at 4 places. > it must has somthing to do with the initialization steps I did following a > article on web. (usr/bin/initdb) > > This makes me think. to do initdb on /data folder is this a MUST do steps > or it's just not necessary? because many articles on well know websites > didn't even mention this step. I wonder what this is for. >
The initdb step creates the PostgreSQL cluster, ie the directory where PostgreSQL puts all the data files, transactions logs files and configuration files. I think you used an RPM package, which launch the initdb step with the directory /var/lib/pgsql/data when you use "/etc/init.d/postgresql initdb". You probably tried on your own to create the /usr/local/pgsql/data cluster directory. And you used the Enterprise DB one-click installer for the /opt/PostgresPlus/8.3/data directory. You only need one data directory. I think it would be better to keep the one generated by the RPM package. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
