Re: [GENERAL] how robust are custom dumps?

2012-05-01 Thread Willy-Bas Loos
great stuff! was that already in it? i'd plea for adding recognition of gzipped data too.. cheers, WBL On Wed, Apr 25, 2012 at 11:05 PM, Guillaume Lelarge guilla...@lelarge.infowrote: On Wed, 2012-04-25 at 10:40 +0200, Willy-Bas Loos wrote: On Wed, Apr 25, 2012 at 9:51 AM, Magnus Hagander

Re: [GENERAL] how robust are custom dumps?

2012-04-25 Thread Willy-Bas Loos
On Tue, Apr 24, 2012 at 10:04 PM, Thom Brown t...@linux.com wrote: What was the experience? Is it possible you had specified a compression level without the format set to custom? That would result in a plain text output within a gzip file, which would then error out if you tried to restore

Re: [GENERAL] how robust are custom dumps?

2012-04-25 Thread Magnus Hagander
On Wed, Apr 25, 2012 at 09:42, Willy-Bas Loos willy...@gmail.com wrote: On Tue, Apr 24, 2012 at 10:04 PM, Thom Brown t...@linux.com wrote: What was the experience?  Is it possible you had specified a compression level without the format set to custom?  That would result in a plain text output

Re: [GENERAL] how robust are custom dumps?

2012-04-25 Thread Willy-Bas Loos
On Wed, Apr 25, 2012 at 9:51 AM, Magnus Hagander mag...@hagander.netwrote: We used to have a bug/lackoffeature in pg_dump at the 2GB boundary as well, IIRC, specifically on Win32. Maybe you were hit by that one.. Yes, possibly. I didn't even know how to make a compressed plain dump, but that

Re: [GENERAL] how robust are custom dumps?

2012-04-25 Thread Guillaume Lelarge
On Wed, 2012-04-25 at 10:40 +0200, Willy-Bas Loos wrote: On Wed, Apr 25, 2012 at 9:51 AM, Magnus Hagander mag...@hagander.netwrote: We used to have a bug/lackoffeature in pg_dump at the 2GB boundary as well, IIRC, specifically on Win32. Maybe you were hit by that one.. Yes, possibly. I

[GENERAL] how robust are custom dumps?

2012-04-24 Thread Willy-Bas Loos
Hi, Some 6 years ago, i had a bad experience with a custom dump. It wouldn't restore and my data was lost. I was a beginner then, and working under windows, and i wasn't on the mailing list yet. It was no critical data, we could build the database again, which was then easier than figuring out

Re: [GENERAL] how robust are custom dumps?

2012-04-24 Thread Andreas Kretschmer
Willy-Bas Loos willy...@gmail.com wrote: Hi, Some 6 years ago, i had a bad experience with a custom dump. It wouldn't restore and my data was lost. I was a beginner then, and working under windows, and i wasn't on the mailing list yet. It was no critical data, we could build the database

Re: [GENERAL] how robust are custom dumps?

2012-04-24 Thread Vick Khera
On Tue, Apr 24, 2012 at 11:17 AM, Willy-Bas Loos willy...@gmail.com wrote: So my question is: what is your advice on custom dumps? Can i bet my life on them? Yes, I would and I do. I've never had a failure as you describe, going back all the way to Postgres 6.5-ish times. Back then I did have

Re: [GENERAL] how robust are custom dumps?

2012-04-24 Thread Thom Brown
On 24 April 2012 16:17, Willy-Bas Loos willy...@gmail.com wrote: Hi, Some 6 years ago, i had a bad experience with a custom dump. It wouldn't restore and my data was lost. What was the experience? Is it possible you had specified a compression level without the format set to custom? That