Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> replay process to take some time. It is strange that it would be locked
> for long enough to allow for manually querying pg_locks and
> pg_stat_activity.
We restarted the standby after maybe 35 mins of application downtime due
to the incident… the diagnostic and restart did happen a tad late in the
process on that ocasion, as it sometimes happens.
So the lock has been kept about that long.
--
Dimitri Fontaine 06 63 07 10 78
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support