Re: psql \copy hanging - Mailing list pgsql-general

From Luca Ferrari
Subject Re: psql \copy hanging
Date
Msg-id CAKoxK+5qWTmmEeGFU8nG3JxGuUKSMUnFtUFkEcjCCYLCWSqaew@mail.gmail.com
Whole thread Raw
In response to Re: psql \copy hanging  ("Arnaud L." <arnaud.listes@codata.eu>)
List pgsql-general
On Tue, Aug 27, 2019 at 9:54 AM Arnaud L. <arnaud.listes@codata.eu> wrote:
> Any other idea ? I'll change the lines order for tonight's run, but that
> is not what I'd call a solution...

Does it hangs against the same line content or the same line number?
Are you able to run the script automatically during working hours (to
avoid firewalling or upgrades running in parrallel to your nightly
script execution)?
Any chance something is querying the same data and a lock blocks the
transaction (pg_locks)?

Just throwing on the table some desperate ideas....

Luca



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: cannot CREATE INDEX because it has pending trigger events
Next
From: "Arnaud L."
Date:
Subject: Re: psql \copy hanging