Bi-directional Replica updates

Dear Postgresql Community, I have been using the "vintage" Rubyrep to replicate some tables on multiple Postgresql 9.6 databases. For performance improving, I'd need to upgrade to Postgresql 12 but, since sequences are managed differently, Rubyrep does not work since it had no updates during la

R: Problem with row-level lock

Dear Adrian, thank you for the reply! >> i am struggling with a problem due, sometime, to a double concurrent update >> on the same row of a table. >What is the error message you get? We have no error, but the two queries, in "Lock wait", keep stucked for some minutes before completed. Are th

Problem with row-level lock

Hi guys, i am struggling with a problem due, sometime, to a double concurrent update on the same row of a table. Since the client application cannot be control, i need to manage - in order to avoid this situation - the lock of a record due to two updates at the same time. Is there way to force

Max open files

Dear all, i am using Bind-DLZ with postgresql and i am experiencing some response problem with a number of concurrent queries above 1000 (about). We use named pipe to connect from Bind DLZ. I noticed that Postgresql 9.6.1 is launched with a max open files. Could be this the problem? How can i ra

Replica on low-bandwitdh network

Hi guys, we have some postgreswl 9.6.1 servers in two different continent. Latency is from 180 to 250 ms between the two sites. Actually we use Rubyrep for off-site replication, since servers are completely independent in case of connectivity loss. We are experiencing some problems with lock ta

R: Problems with triggers and table lock

[melvin6...@gmail.com] Inviato: sabato 2 dicembre 2017 16.22 A: Job Cc: pgsql-gene...@postgresql.org Oggetto: Re: Problems with triggers and table lock On Fri, Dec 1, 2017 at 4:39 PM, Job mailto:j...@colliniconsulting.it>> wrote: Dear guys, we are using Postgresql 9.6.1 with Rubyrep in or

Problems with triggers and table lock

Dear guys, we are using Postgresql 9.6.1 with Rubyrep in order to replicate some tables across two different, and remote, database servers. Since few weeks sometimes when inserting/updating some rows, the statement remains waiting and table seems locked for insert/updates. When i issue "select