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