Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-13 Thread Guillaume Lelarge
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. What did > you > > try that didn't work a

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-07 Thread 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. What did you > try that didn't work as expected? > > > I guess what he means is that if -B is

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-07 Thread Andreas Joseph Krogh
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 mailto:sula...@gmail.com>>: On Mon, Nov 7, 2016 at 2:03 AM, Guillaume Lelarge mailto:guilla...@lelarge.info>> wrote: >> >> Agreed. I was

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-07 Thread Guillaume Lelarge
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. > > 70 - if (dopt.include_everything && !

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-06 Thread 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. 70 - if (dopt.include_everything && !dopt.schemaOnly) 71 + if (dopt.include_everything && !dopt.sc

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-06 Thread Guillaume Lelarge
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 things :) > > >> #1 : >> 43 @@ -392,6 +393,10

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-04 Thread 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 things :) > #1 : > 43 @@ -392,6 +393,10 @@ main(int argc, char **argv) > 44 dopt.output

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-03 Thread amul sul
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

2016-11-03 Thread Guillaume Lelarge
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. v3 (attached) fixes t

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-03 Thread 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. Apart from this concern patch looks good to me. Thanks Regards, Amul The new status of t

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Andreas Joseph Krogh
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 mas

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Guillaume Lelarge
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 Guillaume Lelarge < >> guilla...@lelarge.info>:

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread 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 Guillaume Lelarge < > guilla...@lelarge.info>: > > 2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh : >

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread 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 Andreas Joseph Krogh mailto:a

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Andreas Joseph Krogh
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 mailto:andr...@visena.com>>: På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston mailto:david.g.johns...@gmail.com>

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Guillaume Lelarge
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. 17:38:04, skrev Joshua D. Drake < >> j...@command

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread 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 mailto:andr...@visena.com>> wrote: På tirsdag 08. mars 2016 kl. 17:38:04, skrev Joshua D. Drake < j...@commandprompt

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread David G. Johnston
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

2016-03-08 Thread Andreas Joseph Krogh
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 >: > >     Andreas Joseph Krogh writes:

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Joshua D. Drake
On 03/08/2016 08:02 AM, Andreas Joseph Krogh wrote: På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > What I'm looking for is "inverse -b" in an otherwise complete dump. Any plans > to add that? [ shrug... ]

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Andreas Joseph Krogh
På tirsdag 08. mars 2016 kl. 17:10:43, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: 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 u

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Tom Lane
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 be able to dump a DB (

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Melvin Davidson
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 > > to add that? > > [ shrug... ] Nobody ever asked for it

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Andreas Joseph Krogh
På tirsdag 08. mars 2016 kl. 16:57:01, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: 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   It surely helps t

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Andreas Joseph Krogh
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 >: > >     Andreas Joseph Krogh wri

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread 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 before. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Adrian Klaver
On 03/08/2016 07:46 AM, Andreas Joseph Krogh wrote: På tirsdag 08. mars 2016 kl. 16:30:36, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > P�� tirsdag 08. mars 2016 kl. 15:43:37, skrev Adrian Klaver < > adrian.kla...@aklaver.com

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Andreas Joseph Krogh
På tirsdag 08. mars 2016 kl. 16:30:36, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: 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 ta

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Tom Lane
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 tables with OID-column

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Andreas Joseph Krogh
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 exclu

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Adrian Klaver
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 b

[GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 Thread Andreas Joseph Krogh
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