Re: PostgreSQL over NFS?

* Mike Castle <dalgoda@ix.netcom.com> [010209 16:57] wrote:
> On Fri, Feb 09, 2001 at 04:23:10PM -0800, Alfred Perlstein wrote:
> > Anyhow, if the idea is just to get a nice backup system, you could
> > do a pg_dump and write the output to a NFS mounted FS, there's probably
> > less that can go wrong with a large sequencial write than heavy shared
> > read/write/seek.
>
> Still new to this but....
>
> Can pg_dump be piped through gzip et al?  Use a few cpu strokes to save
> network bandwidth may be beneficial.

Yes it can.  It's a cpu/space/network tradeoff, if you use low
compression you might do pretty well, saving CPU and at the same
time getting pretty good compression on plain-text.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."