Assuming talking of RedHat.
>>>>> "Shridhar" == Shridhar Daithankar <[EMAIL PROTECTED]> writes: Shridhar> When postgres is started as a service like this it Shridhar> always put database location somewhere in /var. I hate Shridhar> loosing flexibility of database location. That's the Shridhar> precise reason I don't use postgres as service but Shridhar> starts it by hand. As a matter of fact, RedHat is correct in putting databases in /var/lib/pgsql. /var/lib is the location specified for "state information pertaining to an application or the system" in the FHS. It goes on to say: "An application (or a group of inter-related applications) must use a subdirectory of /var/lib for its data." Its observation of state information is: "State information should generally remain valid after a reboot, should not be logging output, and should not be spooled data." Seems to me /var/lib/pgsql is the right place for postgres databases. I am not commenting on your need to have a different location for the database, of course; only on the distributor's choice of /var/lib/pgsql. Binand _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help