0 like 0 dislike
66 views
asked by (13.4k points)  
One doubt I have... while we execute pg_dump in backend there will be number of sessions will be created?

Please log in or register to answer this question.

2 Answers

0 like 0 dislike
answered by (13.4k points)  
Check it crontab time if you  set  accidentally every one hours or any minutes ,for example if you set every one hour means if that dump size is large it will start again with other PID once one hour reached so dump will be overwritten, before scheduling crontab set it want to run one month once, other option if once job is run command that crontab job, other option run that pg_dump in background using & and nohub

Then check the idle connection whether its comming over or not
0 like 0 dislike
answered by (13.4k points)  
And check the backup script any loop is there or not if  any loop is there ,possiblity will be there automatically session creation

Related questions

0 like 0 dislike
0 answers
2 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
...