On Thu, 2007-03-22 at 16:59 -0400, Jasbinder Singh Bali wrote: > Hi, > I'm done with my database design and almost got it working (with all > triggers and functions) pefectly. > Now, i need to see how can I make my DB stable, efficient and secure. > > I wanted to know how should I go about it as far as postgres is > concerned > What are the best practices is this regard. > > Any kind of help would be higly appreciated. > (1) Run it on a stable OS (2) Disable write cache on your disks, and make *sure* it's disabled The rest of your question is quite open-ended. Start with the default configuration, read the documentation, experiment on a separate box you don't care about, and you're on the right track. Regards, Jeff Davis
