Pulling initial physical replication pg_basebackup from a downstream server

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

Re: Help troubleshooting SubtransControlLock problems

On Wed, Mar 7, 2018 at 3:50 PM, Alvaro Herrera <alvhe...@alvh.no-ip.org> 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 fa

Re: Help troubleshooting SubtransControlLock problems

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;

Re: Help troubleshooting SubtransControlLock problems

z.a...@cybertec.at> wrote: > Scott Frazer wrote: > > 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 th

Re: Help troubleshooting SubtransControlLock problems

eful (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 Scott Fr

Help troubleshooting SubtransControlLock problems

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 |