Error couldn't not serialize data due to concurrent read write update
Sent from Yahoo Mail on Android - Forwarded Message - From: "Om Prakash Jaiswal" To: "bucardo-gene...@bucardo.org" Cc: Sent: Thu, Aug 2, 2018 at 18:56 Subject: How stop acknowledgement of transmitted data Hi I am running bucardo 4.4 version on postgresql 9.4.8 RHEL 7.3 64bit OS. It is geographically distributed nodes using as master master replication.Data are coming from sensors at 200tracks/second. One track size 100bytes network bandwidth 50mbps. I am getting error could not serialize concurrent read/write update.On bucardo_track table concurrent update.I configured isolation level repeatable read and later serialize level in postgresql configuration file. Restarted postgresql also. Still I am getting similar error.I want to stop getting acknowledgement from bucardo.My aim is to Only transmit data. Still bucardo is synchronising data, only failure transaction is not synchronising.Please help me. Thanks in advance RegardsOm Prakash,DBABangaloreMob 9035635787 Sent from Yahoo Mail on Android
Request for example using pqconnectstart,pqconnectpoll part.
Hi,Please provide a sample example using pqconnectstart , pqconnectpoll to make a asynchronous connection and executing a query for client application in C.It is part of libpq - C Library. I am able to do query using PQconnectdb and PQexec.I have also used PQconnectdb and PQsendQuery. PQconnectdb is blocking call, now I want to replace PQconnectdb with non blocking connection pqconnectstart and pqconnectpoll. Please provide an example. Thanks in advance. RegardsOm PrakashDBA, Bangalore
Db restore Error literal carriage return found hint use \r
I am using postgresql 10.6While restore data using psql, error getting literal carriage return found line no. 4446578 hint use \r I used \i and \r , still getting same error.Backup size 35GB plain databack up.Data type JSON in which I am getting error while copy ing in restore operation. Please solve it. Regards Om PrakashBangalore Sent from Yahoo Mail on Android
Getting wrong time using now()
Create table service_record(Id into, time timestamp without time zone default now()).Postgresql version 9.6.6, RHEL7.6 , when I am executing the query. I am getting time 5:30hours behind current time. Please solve it RegardsOm PrakashBangalore, India Sent from Yahoo Mail on Android
