Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-08 6:01 GMT+01:00 amul sul : > On Tue, Nov 8, 2016 at 5:36 AM, Andreas Joseph Krogh > wrote: > > > > > > I don't see what you mean. It forces dump of Blobs if we didn't use -B > and > > if we include everything in the dump, which seems good to me.

Re: [GENERAL] Exclude pg_largeobject form pg_dump

On Tue, Nov 8, 2016 at 5:36 AM, Andreas Joseph Krogh wrote: > > > I don't see what you mean. It forces dump of Blobs if we didn't use -B and > if we include everything in the dump, which seems good to me. What did you > try that didn't work as expected? > > > I guess what he

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På mandag 07. november 2016 kl. 22:01:41, skrev Guillaume Lelarge < guilla...@lelarge.info >: 2016-11-07 7:06 GMT+01:00 amul sul >: On Mon, Nov 7, 2016 at 2:03 AM, Guillaume Lelarge

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-07 7:06 GMT+01:00 amul sul : > On Mon, Nov 7, 2016 at 2:03 AM, Guillaume Lelarge > wrote: > >> > >> Agreed. I was afraid of that, but for some reason, didn't find that. > I'll > >> fix this. > > > > > > Fixed in v4. > > > > This fix is broken. >

Re: [GENERAL] Exclude pg_largeobject form pg_dump

On Mon, Nov 7, 2016 at 2:03 AM, Guillaume Lelarge wrote: >> >> Agreed. I was afraid of that, but for some reason, didn't find that. I'll >> fix this. > > > Fixed in v4. > This fix is broken. 70 - if (dopt.include_everything && !dopt.schemaOnly) 71 + if

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-04 9:35 GMT+01:00 Guillaume Lelarge : > Hi Amul, > > 2016-11-04 7:52 GMT+01:00 amul sul : > >> Hi Guillaume, >> >> I found following issues with this patch, sorry missed in previous post: >> >> > You don't have to be sorry for me doing shitty

Re: [GENERAL] Exclude pg_largeobject form pg_dump

Hi Amul, 2016-11-04 7:52 GMT+01:00 amul sul : > Hi Guillaume, > > I found following issues with this patch, sorry missed in previous post: > > You don't have to be sorry for me doing shitty things :) > #1 : > 43 @@ -392,6 +393,10 @@ main(int argc, char **argv) > 44

Re: [GENERAL] Exclude pg_largeobject form pg_dump

Hi Guillaume, I found following issues with this patch, sorry missed in previous post: #1 : 43 @@ -392,6 +393,10 @@ main(int argc, char **argv) 44 dopt.outputBlobs = true; 45 break; 46 47 + case 'B': /* Don't dump blobs */ 48 +

Re: [GENERAL] Exclude pg_largeobject form pg_dump

Hi, 2016-11-03 8:22 GMT+01:00 amul sul : > Hi Guillaume, > > With your v2 patch, -B options working as expected but --no-blobs > options is still unrecognized, this happens is because of you have > forgot to add entry for 'no-blobs' in long_options[] array. > > You're right.

Re: [GENERAL] Exclude pg_largeobject form pg_dump

Hi Guillaume, With your v2 patch, -B options working as expected but --no-blobs options is still unrecognized, this happens is because of you have forgot to add entry for 'no-blobs' in long_options[] array. Apart from this concern patch looks good to me. Thanks Regards, Amul The new status of

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På søndag 23. oktober 2016 kl. 20:44:34, skrev Guillaume Lelarge < guilla...@lelarge.info >: [snip] Remember that, if it gets commited, it'll be for next release (aka 10), and not 9.6 and earlier.   The patch working for 9.6 is fine for me, but getting this in

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 20:44 GMT+02:00 Guillaume Lelarge : > 2016-10-23 20:37 GMT+02:00 Andreas Joseph Krogh : > >> På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh < >> andr...@visena.com>: >> >> På søndag 23. oktober 2016 kl. 17:06:57, skrev

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 20:37 GMT+02:00 Andreas Joseph Krogh : > På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh < > andr...@visena.com>: > > På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge < > guilla...@lelarge.info>: > > 2016-03-08 21:06 GMT+01:00

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh < andr...@visena.com >: På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge < guilla...@lelarge.info >: 2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge < guilla...@lelarge.info >: 2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh >: På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh : > På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston < > david.g.johns...@gmail.com>: > > On Tue, Mar 8, 2016 at 9:45 AM, Andreas Joseph Krogh > wrote: > >> På tirsdag 08. mars 2016 kl.

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston < david.g.johns...@gmail.com >: On Tue, Mar 8, 2016 at 9:45 AM, Andreas Joseph Krogh > wrote: På tirsdag 08. mars 2016 kl. 17:38:04, skrev Joshua D.

Re: [GENERAL] Exclude pg_largeobject form pg_dump

On Tue, Mar 8, 2016 at 9:45 AM, Andreas Joseph Krogh wrote: > På tirsdag 08. mars 2016 kl. 17:38:04, skrev Joshua D. Drake < > j...@commandprompt.com>: > > On 03/08/2016 08:02 AM, Andreas Joseph Krogh wrote: > > På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 17:38:04, skrev Joshua D. Drake < j...@commandprompt.com >: On 03/08/2016 08:02 AM, Andreas Joseph Krogh wrote: > På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane >: > >     

Re: [GENERAL] Exclude pg_largeobject form pg_dump

On 03/08/2016 08:02 AM, Andreas Joseph Krogh wrote: På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane >: Andreas Joseph Krogh writes: > What I'm looking for is "inverse -b" in an otherwise complete dump. Any

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 17:10:43, skrev Tom Lane >: Andreas Joseph Krogh writes: > P�� tirsdag 08. mars 2016 kl. 16:54:19, skrev Adrian Klaver < > adrian.kla...@aklaver.com >: >  Off hand

Re: [GENERAL] Exclude pg_largeobject form pg_dump

Andreas Joseph Krogh writes: > PÃ¥ tirsdag 08. mars 2016 kl. 16:54:19, skrev Adrian Klaver < > adrian.kla...@aklaver.com >: > Off hand I would say you are running pg_dump as a user that is not a > superuser: > Yes, since when should I not

Re: [GENERAL] Exclude pg_largeobject form pg_dump

On Tue, Mar 8, 2016 at 11:02 AM, Andreas Joseph Krogh wrote: > På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane : > > Andreas Joseph Krogh writes: > > What I'm looking for is "inverse -b" in an otherwise complete dump. Any > plans

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane >: Andreas Joseph Krogh writes: > What I'm looking for is "inverse -b" in an otherwise complete dump. Any plans > to add that? [ shrug... ]  Nobody ever asked for it

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 16:54:19, skrev Adrian Klaver < adrian.kla...@aklaver.com >: On 03/08/2016 07:46 AM, Andreas Joseph Krogh wrote: > På tirsdag 08. mars 2016 kl. 16:30:36, skrev Tom Lane >: > >     

Re: [GENERAL] Exclude pg_largeobject form pg_dump

Andreas Joseph Krogh writes: > What I'm looking for is "inverse -b" in an otherwise complete dump. Any plans > to add that? [ shrug... ] Nobody ever asked for it before. regards, tom lane -- Sent via pgsql-general mailing list

Re: [GENERAL] Exclude pg_largeobject form pg_dump

On 03/08/2016 07:46 AM, Andreas Joseph Krogh wrote: På tirsdag 08. mars 2016 kl. 16:30:36, skrev Tom Lane >: Andreas Joseph Krogh writes: > P�� tirsdag 08. mars 2016 kl. 15:43:37, skrev Adrian Klaver < >

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 16:30:36, skrev Tom Lane >: Andreas Joseph Krogh writes: > P�� tirsdag 08. mars 2016 kl. 15:43:37, skrev Adrian Klaver < > adrian.kla...@aklaver.com >: >  Do you

Re: [GENERAL] Exclude pg_largeobject form pg_dump

Andreas Joseph Krogh writes: > PÃ¥ tirsdag 08. mars 2016 kl. 15:43:37, skrev Adrian Klaver < > adrian.kla...@aklaver.com >: > Do you care about not dumping the pg_largeobject table or not dumping > the data it contains? > > I have several

Re: [GENERAL] Exclude pg_largeobject form pg_dump

På tirsdag 08. mars 2016 kl. 15:43:37, skrev Adrian Klaver < adrian.kla...@aklaver.com >: On 03/08/2016 01:53 AM, Andreas Joseph Krogh wrote: > Hi all. > Is there a way to exclude pg_largeobject from pg_dump? -T pg_largeobject > doesn't work. I've tried to

Re: [GENERAL] Exclude pg_largeobject form pg_dump

On 03/08/2016 01:53 AM, Andreas Joseph Krogh wrote: Hi all. Is there a way to exclude pg_largeobject from pg_dump? -T pg_largeobject doesn't work. I've tried to exclude tables using OID-datatype also but that didn't work either. Well pg_largeobject is a system catalog so pretty sure it cannot

[GENERAL] Exclude pg_largeobject form pg_dump

Hi all.   Is there a way to exclude pg_largeobject from pg_dump? -T pg_largeobject doesn't work. I've tried to exclude tables using OID-datatype also but that didn't work either.   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com