I'm changing out a data center and I need to setup a new replicated server.
The bandwidth speeds between the new data center and the master are slower
than the speeds between the new data center and the current replica.
Can I get the pg_base_backup from the current replica and then tell the new
se
On Wed, Mar 7, 2018 at 3:50 PM, Alvaro Herrera
wrote:
>
> Scott Frazer wrote:
>
> > It's only happening on the read replicas, though. I've just set my
master
> > to handle all the traffic, but that's not really sustainable
>
> I failed to notice at st
On Wed, Mar 7, 2018 at 10:39 AM, Alvaro Herrera
wrote:
>
> Laurenz Albe wrote:
> I think you could get in this situation if the range of open
> transactions exceeds what fits in the buffers for subtrans.c pages, and
> the subtransaction cache overflows (64 entries apiece;
> PGPROC_MAX_CACHED_SUBXI
Server version is 9.6.5
Is there a decent guide to getting a stack trace on Centos7 when using the
official Postgres repo? trying to follow the Fedora guide put the debug
info for 9.2.23 on the box instead of the 9.6.5 version.
On Wed, Mar 7, 2018 at 9:52 AM, Laurenz Albe
wrote:
> Scott Fra
ry useful (the first one):
> https://wiki.postgresql.org/wiki/Lock_Monitoring
>
> Examine blocking_pid's , and tell us what kind of operation is blocking
> the other processes . Also, are there many long running transactions in
> your server?
>
>
> 2018-03-06 21:24 GMT-06:00
Hi, we have a Postgres 9.6 setup using replication that has recently
started seeing a lot of processes stuck in "SubtransControlLock" as a
wait_event on the read-replicas. Like this, only usually about 300-800 of
them:
179706 | LWLockNamed | SubtransControlLock
186602 | LWLockNamed | S
