So I just had postgres got to 80% CPU for about 15 minutes. I have two questions:
1) Where would I start in trying to track down what happened? I ran this query but unfortunately after the fact: SELECT pid, datname, usename, query FROM pg_stat_activity; I spelunking in the logs right now but there's a lot of noise.
2) This is a more general question, what is postgres's relationship with Freeswitch and Fusion. In FreePbx I could loose the DB and I mostly only lost the gui, CDR's couldn't write but for the most part the switch kept functioning. In Freeswitch/Fusion if loose the DB what are the ramifications? Do I loose everything? If I restart Postgres while in production do I also need to restart Freeswitch? Is there any tolerance for a failure (like in a restart situation) ?
At this point I'm thinking I need to move postgres to it's own set of servers, has anyone had any issues separating the DB from fusion?
1) Where would I start in trying to track down what happened? I ran this query but unfortunately after the fact: SELECT pid, datname, usename, query FROM pg_stat_activity; I spelunking in the logs right now but there's a lot of noise.
2) This is a more general question, what is postgres's relationship with Freeswitch and Fusion. In FreePbx I could loose the DB and I mostly only lost the gui, CDR's couldn't write but for the most part the switch kept functioning. In Freeswitch/Fusion if loose the DB what are the ramifications? Do I loose everything? If I restart Postgres while in production do I also need to restart Freeswitch? Is there any tolerance for a failure (like in a restart situation) ?
At this point I'm thinking I need to move postgres to it's own set of servers, has anyone had any issues separating the DB from fusion?