Обсуждение: [ADMIN] Database goes in recovery mode
Hello team,
My database goes in recovery mode every day three to four time , i am not able to find the reason, db basic configuration is max_connection = 1000 , db size 100GB and configure barman for backup. please help me.--
Ashok Kumar Tiwari,
M:+91-9657628833
Save a tree. Please avoid printing this email unless necessary.
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
On Fri, Oct 13, 2017 at 7:31 AM, Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote: > > Hello team, > > My database goes in recovery mode every day three to four time , i am not able to find the reason, db basic configurationis max_connection = 1000 , db size 100GB and configure barman for backup. please help me. Check your server logs for the out of memory killer. With max conns of 1000 it's quite possible your machine is running out of memory. Also please post any changed values in postgresql.conf -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
On Fri, Oct 13, 2017 at 7:01 PM, Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:
Hello team,My database goes in recovery mode every day three to four time , i am not able to find the reason, db basic configuration is max_connection = 1000 , db size 100GB and configure barman for backup. please help me.
--Ashok Kumar Tiwari,M:+91-9657628833Save a tree. Please avoid printing this email unless necessary.
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
Hi Ashok Kumar Tiwari,
We are pleased to help you, but in this regard request to provide the exact issue in detail you are facing...
Looking forward for a positive response.
Please reply all to keep the list updated...
On Fri, Oct 13, 2017 at 9:07 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:On Fri, Oct 13, 2017 at 7:31 AM, Ashok Kumar Tiwari
<ashokt@ohumhealthcare.com> wrote:
>
> Hello team,
>
> My database goes in recovery mode every day three to four time , i am not able to find the reason, db basic configuration is max_connection = 1000 , db size 100GB and configure barman for backup. please help me.
Check your server logs for the out of memory killer. With max conns of
1000 it's quite possible your machine is running out of memory.
Also please post any changed values in postgresql.conf
<ashokt@ohumhealthcare.com> wrote:
i found in my db log file2017-10-11 18:35:20.769 IST > LOG: checkpointer process (PID 31936) was terminated by signal 9: Killed< 2017-10-11 18:35:20.769 IST > LOG: terminating any other active server processesis this is out of memory?my server have 8 GB ramVery likely. Look around in the /var/log/messages around the same time for mention of the Out Of Memory killer (aka OOM). You're probably going to need to reduce max connections and then add something like pgbouncer or pgpool to reduce 1,000 outside connections down to something like 10 or 20 or so.
On Sat, Oct 14, 2017 at 9:22 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote: > Please reply all to keep the list updated... > >> On Fri, Oct 13, 2017 at 9:07 PM, Scott Marlowe <scott.marlowe@gmail.com> >> wrote: >>> >>> On Fri, Oct 13, 2017 at 7:31 AM, Ashok Kumar Tiwari >>> <ashokt@ohumhealthcare.com> wrote: >>> > >>> > Hello team, >>> > >>> > My database goes in recovery mode every day three to four time , i am >>> > not able to find the reason, db basic configuration is max_connection = 1000 >>> > , db size 100GB and configure barman for backup. please help me. >>> >>> Check your server logs for the out of memory killer. With max conns of >>> 1000 it's quite possible your machine is running out of memory. >>> >>> Also please post any changed values in postgresql.conf >> >> >> >> > <ashokt@ohumhealthcare.com> wrote: >> >> i found in my db log file >> >> 2017-10-11 18:35:20.769 IST > LOG: checkpointer process (PID 31936) was >> terminated by signal 9: Killed >> < 2017-10-11 18:35:20.769 IST > LOG: terminating any other active server >> processes >> >> is this is out of memory? >> my server have 8 GB ram >> >> >> Very likely. Look around in the /var/log/messages around the same time for >> mention of the Out Of Memory killer (aka OOM). You're probably going to >> need to reduce max connections and then add something like pgbouncer or >> pgpool to reduce 1,000 outside connections down to something like 10 or 20 >> or so. Also look into to turning off the out of memory killer. It's a linux "feature" that is not desirable on a db server. Something like in this thread: https://ubuntuforums.org/showthread.php?t=2197016 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin