Postgresql Questions

view story

http://forums.fedoraforum.org – I'm currently running Fedora 17 and am considering running Postgresql as a database server. In looking over the install of postgres I notice that it is installed in /var/lib and the database data is kept there also. Why is the postgres user and the database data not kept somewhere that is not so intergrated into the OS. I would much prefer the user to be in /home and the database data to be in a separate mounted file system. I noticed that mysql is set up exactly the same. It would seem to be to cause many problems when upgrading from one release to another. Even my backup scheme (HowTos)