Re: pg_restore encounter deadlock since PostgreSQL bringing up

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'zh1029 *EXTERN*'" <zh1029(at)sina(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore encounter deadlock since PostgreSQL bringing up
Date: 2015-11-17 09:35:49
Message-ID: A737B7A37273E048B164557ADEF4A58B50FE64BB@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

zh1029 wrote:
> While start PostgreSQL(9.3.6) and execute pg_restore soon after PostgreSQL
> bringing up. I encounter pg_restore failure because of deadlock detected.

pg_restore will not deadlock with itself or system startup.

Set log_connections to "on", then you will see who connected and
caused the deadlock.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ramesh T 2015-11-17 12:18:36 Re: Taking lot time
Previous Message Geoff Winkless 2015-11-17 09:14:40 Re: referencing other INSERT VALUES columns inside the insert