Thread: making postgres DB stable, efficient and secure

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.

Thanks,
~Jas

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 03/22/07 15:59, 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.

Your database is not stable????????

You host it on Windows?

>
> 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.

Start with what you do on any database: GRANT/REVOKE and creating
indexes that match your queries, updates & deletes without impact
inserts.

Next is buffer sizing.
   http://www.postgresql.org/docs/8.2/interactive/

What version are you running?

>
> Thanks,
> ~Jas

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGAvOhS9HxQb37XmcRAmHNAKCqpB/mTInSjjRmOR3ql+rKXZdW5ACgo208
f6RLxC9ypHHqcMqNAxylNF8=
=tsED
-----END PGP SIGNATURE-----

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