Re: [GENERAL] wal files stay in the pg_xlog dir

2015-08-30 Thread kingl
Hi Adrian Thank you for your explanation, I did read the wal document that you mentioned and every settings look ok. I will keep an eye on the situation and I really appreciate your help. -- View this message in context: http://postgresql.nabble.com/wal-files-stay-in-the-pg-xlog-dir-tp586378

Re: [GENERAL] wal files stay in the pg_xlog dir

2015-08-28 Thread kingl
Hi Adrian Thank you for your prompt reply. In the pg_xlog there are 2,015 wal files now. repmgr recommends to keep 5000 wal files however for our env that would be an overkill so i changed it to 2000. the other issue is that the standby node has only 1345 wal files in the pg_xlog, i thought tha

[GENERAL] wal files stay in the pg_xlog dir

2015-08-28 Thread kingl
To whom it may concern: We have a 2 nodes postgres cluster, postgres server v9.3.8 and repmgr is used to enable the cluster function. barman v1.4.1 is used to take backup of the master postgres node. everything seems to be working except the wal files in pg_xlog on node1 keeps accumulating. ther