From: Marc Cousin <cousinmarc@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: pg_restore -j mixed and missing lines of output
Date: Thu, 1 Sep 2011 16:10:52 +0200
Message-ID: <20110901161052.38981e9b@marco-dalibo> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cousinmarc@gmail.com
Subject: Re: pg_restore -j mixed and missing lines of output
In-Reply-To: <20110901161052.38981e9b@marco-dalibo>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox