Re: Why is my Postgre server went in recovery mode all in sudden

2018-05-11 Thread Adrian Klaver
On 05/11/2018 03:30 AM, nikhil raj wrote: Hi Adrian Klaver, No its like it opens  connection and once the query gets execute it goes to idle connection and again idle connection time out i kept it for 2 mins . It never happen again. need few answers why will share buffer crashes ? From the

Re: Why is my Postgre server went in recovery mode all in sudden

2018-05-11 Thread nikhil raj
Hi Adrian Klaver, No its like it opens connection and once the query gets execute it goes to idle connection and again idle connection time out i kept it for 2 mins . It never happen again. need few answers why will share buffer crashes ? Thanks, On Thu, May 10, 2018 at 7:28 PM, Adrian Klav

Re: Why is my Postgre server went in recovery mode all in sudden

2018-05-10 Thread Adrian Klaver
On 05/10/2018 04:42 AM, nikhil raj wrote: 1) What OS and version? ans: windows 2012R2 2) System memory size is ? ans: 32GB 3) What is session_start_timestamp tracking? In other words what does it match up to here: ans: This is the format to timestamp=%m,user=%u,db=%d,app=%a,client=%h,transa

Re: Why is my Postgre server went in recovery mode all in sudden

2018-05-10 Thread nikhil raj
1) What OS and version? ans: windows 2012R2 2) System memory size is ? ans: 32GB 3) What is session_start_timestamp tracking? In other words what does it match up to here: ans: This is the format to timestamp=%m,user=%u,db=%d,app=%a,client=%h,transaction- ID=%x,session_start_timestamp=%s,SQL_s

Re: Why is my Postgre server went in recovery mode all in sudden

2018-05-09 Thread Adrian Klaver
On 05/09/2018 11:31 AM, nikhil raj wrote: Hi Team, I dont have any idea why did my Postgres server crash and it says timestamp=2018-05-07 00:34:11.209 EDT,user=,db=,app=,client=,transaction-ID=0,session_start_timestamp=2018-04-26 10:08:19 EDT,SQL_state=0LOG:  worker process: parallel work

Why is my Postgre server went in recovery mode all in sudden

2018-05-09 Thread nikhil raj
Hi Team, I dont have any idea why did my Postgres server crash and it says timestamp=2018-05-07 00:34:11.209 EDT,user=,db=,app=,client=, transaction-ID=0,session_start_timestamp=2018-04-26 10:08:19 EDT,SQL_state=0LOG: worker process: parallel worker for PID 2864 (PID 4476) exited with exit c