On Tue, Aug 13, 2002 at 04:53:47PM +0100, strange@nsk.yi.org wrote:
> On Tue, Aug 13, 2002 at 11:31:15AM -0400, Andrew Sullivan wrote:
> > On Tue, Aug 13, 2002 at 05:19:31PM +0200, Helge Bahmann wrote:
> > > If all the 2GB problem is only about pg_dump may I suggest a work-around?
> > >
> > > pg_dump | cat >dumpfile.sql
> > >
> > > works without problems if "cat" is largefile-enabled;
> >
> > I had that break on Solaris. Makes no sense to me, either, but it
> > most certainly did.
>
> Does the shell have large file support?
Yep. It was an error from pg_dump that claimed it couldn't keep
writing. Never seen anything like it. I'm sure I did something
wrong somewhere, I just didn't see what it was. (In the end, I just
recompiled pg_dump.) But _something_ along the chain didn't have
large file support. It's these sorts of little gotchas that I was
thinking of when I said that just turning on large files is not that
simple: you really need to know that _everything_ is ready, or the
errors you get will surprise you.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M6K 3E3
+1 416 646 3304 x110