Re: making postgres DB stable, efficient and secure

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