Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore encounter deadlock since PostgreSQL bringing up - Mailing list pgsql-general

From Albe Laurenz
Subject Re: pg_restore encounter deadlock since PostgreSQL bringing up
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50FE64BB@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to pg_restore encounter deadlock since PostgreSQL bringing up  (zh1029 <zh1029@sina.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: referencing other INSERT VALUES columns inside the insert
Next
From: John McKown
Date:
Subject: Re: postgreSQL.conf has become zero byte file