Re: [GENERAL] pg_dump's over 2GB

2000-09-29 Thread Ross J. Reedstrom
On Fri, Sep 29, 2000 at 11:41:51AM -0500, Jeff Hoffmann wrote: > Bryan White wrote: > > > > I am thinking that > > instead I will need to pipe pg_dumps output into gzip thus avoiding the > > creation of a file of that size. > > sure, i do it all the time. unfortunately, i've had it happen a few

Re: [GENERAL] pg_dump's over 2GB

2000-09-29 Thread Jeff Hoffmann
Bryan White wrote: > > I am thinking that > instead I will need to pipe pg_dumps output into gzip thus avoiding the > creation of a file of that size. > sure, i do it all the time. unfortunately, i've had it happen a few times where even gzipping a database dump goes over 2GB, which is a real

Re: [GENERAL] pg_dump's over 2GB

2000-09-29 Thread Steve Wolfe
> My current backups made with pg_dump are currently 1.3GB. I am wondering > what kind of headaches I will have to deal with once they exceed 2GB. > > What will happen with pg_dump on a Linux 2.2.14 i386 kernel when the output > exceeds 2GB? There are some ways around it if your program suppor

Re: [GENERAL] pg_dump's over 2GB

2000-09-29 Thread Adam Haberlach
On Fri, Sep 29, 2000 at 12:15:26PM -0400, Bryan White wrote: > My current backups made with pg_dump are currently 1.3GB. I am wondering > what kind of headaches I will have to deal with once they exceed 2GB. > > What will happen with pg_dump on a Linux 2.2.14 i386 kernel when the output > exceed