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