Postgres on SAN

Question

I have two postgres nodes with a shared storage (only for data, not for config), works simply by stopping postgres on one side and starting it on the other. Pacemaker (PAF) handles stop/start between the nodes.

Questions:

What type of PostgreSQL configuration is recommended in this scenario?

Should I setup WAL archiving for some PITR and snapshots of the SAN volume, WAL archiving on both nodes etc?

I am just after some tips and guidelines here as it seems it's not a very common use case.

Thanks!

Answer 1

first Postgres Pro cannot be more reliable than the file system it's using. But if you want use SAN you can try DRBD. If you have a licanse on disk array massive you can create san replica or metrocluster. About snapshots. I think you need VEEAM.