Can I move the PostgresQL
Posted: Fri Jun 20, 2014 2:05 pm
Hello all,
I installed Nagios XI from the VM template provided on the Nagios website. We are finding the VM is a bit to small as we are running out of space/memory/cpu.
We are adding more CPU's and more Memory to the VM as we speak but would like to offload some of the DB work.
I found a user guide on how to move the MySQL db but nothing on the PostgresQL. When we run top it seems PostgresQL is eating up most of our system resources.
So questions are:
- What does Nagios use PostgresQL vs MySql for?
- Can we move the PostgresQL db to a new HD on the VM ?
- Can we offload PostgresQL & MySQL to a different VM ?
Thank you,
Brandon
I installed Nagios XI from the VM template provided on the Nagios website. We are finding the VM is a bit to small as we are running out of space/memory/cpu.
We are adding more CPU's and more Memory to the VM as we speak but would like to offload some of the DB work.
I found a user guide on how to move the MySQL db but nothing on the PostgresQL. When we run top it seems PostgresQL is eating up most of our system resources.
So questions are:
- What does Nagios use PostgresQL vs MySql for?
- Can we move the PostgresQL db to a new HD on the VM ?
- Can we offload PostgresQL & MySQL to a different VM ?
Thank you,
Brandon