pg_restore -j mixed and missing lines of output

From: Marc Cousin <cousinmarc(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)org>
Subject: pg_restore -j mixed and missing lines of output
Date: 2011-09-01 14:10:52
Message-ID: 20110901161052.38981e9b@marco-dalibo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I don't know if this is a known problem, or something I'm doing wrong,
but pg_restore -j tends to sometimes mix lines, or even completely
drop some. Here is an example (it's a -j12 run):

pg_restore: pg_restore: restoring data for table "edw_iu_paglac_axe1_kpi_lac_month_bh"
restoring data for table "edw_iu_paglac_axe1_kpi_lac_month"

This is one case when nothing is lost, messages only get mixed. Sometimes,
entire lines disappear (a table's data is restored, but I don't get the
'restoring' or 'finished' message lines).

This is on Linux, so looking at pg_restore's code, I read that workers are forked
and printing all on the same file descriptor without locking, so I understand
that messages are mixed like this example. I couldn't find any explanation to
the dropped messages though.

Anyway, I don't know if this is a known problem. I searched the mailing list
with no success. I can provide a full log of a complete restore, without and
with -j.

Thanks,

Marc

Browse pgsql-admin by date

  From Date Subject
Next Message Geoff Tolley 2011-09-01 22:41:48 Alter column varchar(n) via updating pg_attribute
Previous Message Gabriele Bartolini 2011-09-01 13:54:34 Re: Password when logging into postgres