Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:
> Do you use any spesial option when you compile pg_dump, or in the
> program that could influence how the program behaves and can help me to
> reproduce the problem?
In a Linux system we'll add "-D_GNU_SOURCE" to the compile command line.
Also,
On Fri, 2005-03-18 at 15:58, Tom Lane wrote:
> Rafael Martinez <[EMAIL PROTECTED]> writes:
> > On Thu, 2005-03-17 at 10:17 -0500, Tom Lane wrote:
> >> Is that a plain text, tar, or custom dump (-Ft or -Fc)? Is the behavior
> >> different if you just write to stdout instead of using --file?
>
> >
Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:
> We are trying to dump a 30GB+ database using pg_dump with the --file
> option. In the beginning everything works fine, pg_dump runs and we get
> a dumpfile. But when this file becomes 16GB it disappears from the
> filesystem,
FWIW, I tried and
On Fri, 2005-03-18 at 09:58 -0500, Tom Lane wrote:
> Rafael Martinez <[EMAIL PROTECTED]> writes:
> > On Thu, 2005-03-17 at 10:17 -0500, Tom Lane wrote:
> >> Is that a plain text, tar, or custom dump (-Ft or -Fc)? Is the behavior
> >> different if you just write to stdout instead of using --file?
>
Rafael Martinez <[EMAIL PROTECTED]> writes:
> On Thu, 2005-03-17 at 10:17 -0500, Tom Lane wrote:
>> Is that a plain text, tar, or custom dump (-Ft or -Fc)? Is the behavior
>> different if you just write to stdout instead of using --file?
> - In this example, it is a plain text (--format=3Dp).
> -
On Thu, 2005-03-17 at 10:41 -0700, Aly Dharshi wrote:
Hello
> Would it help to use a different filesystem like SGI's XFS ?
I do not see the connection between this problem and using another
filesystem. I think we would have this problem with all the programs in
the system if we had a problem wit
On Thu, 2005-03-17 at 10:17 -0500, Tom Lane wrote:
> Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:
> > We are trying to dump a 30GB+ database using pg_dump with the --file
> > option. In the beginning everything works fine, pg_dump runs and we get
> > a dumpfile. But when this file becomes 1
Would it help to use a different filesystem like SGI's XFS ? Would it be
possible to even implement that at you site at this stage ?
Tom Lane wrote:
Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:
We are trying to dump a 30GB+ database using pg_dump with the --file
option. In the beginning e
Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:
> We are trying to dump a 30GB+ database using pg_dump with the --file
> option. In the beginning everything works fine, pg_dump runs and we get
> a dumpfile. But when this file becomes 16GB it disappears from the
> filesystem, pg_dump continues
On Thu, 17 Mar 2005, Rafael Martinez Guerrero wrote:
My question is why is this limit (16GB) there, when my OS does not have
that limit? Is it possible to take it away in a easy way? It looks like
pg_dump is compiled with large-file support because it can work with
files bigger than 4GB.
More ideas
On Thu, 2005-03-17 at 15:09, Lonni J Friedman wrote:
> On Thu, 17 Mar 2005 14:05:35 +0100, Rafael Martinez Guerrero
> <[EMAIL PROTECTED]> wrote:
> > Hello
> >
> > We are having problems with pg_dump.
> >
> > We are trying to dump a 30GB+ database using pg_dump with the --file
> > option. In the b
On Thu, 2005-03-17 at 15:05, Michael Kleiser wrote:
> I found on http://www.madeasy.de/7/ext2.htm (in german)
> ext2 can't have bigger files than 16GB if blocksize is 1k.
> Ext3 is ext2 with journaling.
>
[]
We use 4k. And as I said, we can generate files bigger than 16GB with
other
On Thu, 17 Mar 2005 14:05:35 +0100, Rafael Martinez Guerrero
<[EMAIL PROTECTED]> wrote:
> Hello
>
> We are having problems with pg_dump.
>
> We are trying to dump a 30GB+ database using pg_dump with the --file
> option. In the beginning everything works fine, pg_dump runs and we get
> a dumpfile.
I found on http://www.madeasy.de/7/ext2.htm (in german)
ext2 can't have bigger files than 16GB if blocksize is 1k.
Ext3 is ext2 with journaling.
Rafael Martinez Guerrero wrote:
Hello
We are having problems with pg_dump.
We are trying to dump a 30GB+ database using pg_dump with the --file
option.
Hello
We are having problems with pg_dump.
We are trying to dump a 30GB+ database using pg_dump with the --file
option. In the beginning everything works fine, pg_dump runs and we get
a dumpfile. But when this file becomes 16GB it disappears from the
filesystem, pg_dump continues working without
15 matches
Mail list logo
