Can I move the PostgresQL

[brandon.pal]

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

[slansing]

Currently, it is not quite possible to offload postgresql, we have been looking at ways of doing this but right now you can only offload MySql. MySql hogs the most resources out of the two, and is much larger.