From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Nico De Ranter <nico(dot)deranter(at)esaturnus(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump crashes |
Date: | 2020-05-22 15:09:53 |
Message-ID: | 3120cb66-0b6c-c78b-8d96-eb7d13e1352e@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5/22/20 8:05 AM, Nico De Ranter wrote:
>
> On Fri, May 22, 2020 at 5:02 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 5/22/20 7:55 AM, Nico De Ranter wrote:
> > Correct.
> >
> > If I run 'pg_dumpall --cluster 11/main --file=dump.sql' the end
> of the
> > file looks like:
> >
> > ###### cut here
> > 4557430888798830399 1061109567 1061109567 1061109567 1061109567
> 16191 \N
> > \N ??????????????????????????????
> > 4557430888798830399 1061109567 1061109567 1061109567 1061109567
> 16191 \N
> > \N ??????????????????????????????
> > \.
> >
> > ###### cut here
> >
> > If I run 'pg_dump --table=public.file --cluster 11/main
> > --file=dump-2.sql bacula' those lines are actually followed by
> about
> > 850 or so lines that look ok. I'm assuming the difference is due to
> > buffering.
> > However the fact that I do see a number of regular lines
> following this
> > may suggest it's just garbage in the table but not really causing
> the
> > issue afterall.
>
> Assuming the above matches:
>
> COPY public.file (fileid, fileindex, jobid, pathid, filenameid,
> deltaseq, markid, lstat, md5)
>
> the '????????????????????' would be for the md5 field. I'm going to say
> that is important.
>
>
> But that would be content of the database only. The should matter for
> the application but not for a dump of the database, right?
I would think that depends on what '???????' is really representing.
In the database try:
SELECT md5 FROM public.file where fileid = 4557430888798830399;
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Nico De Ranter | 2020-05-22 15:11:14 | Re: pg_dump crashes |
Previous Message | Adrian Klaver | 2020-05-22 15:06:59 | Re: pg_dump crashes |