I have some comments to the documentation.
I worked with PostgreSQL for some time ago( 5-8 years) setting up a few Postgres databases using version 8.4 and RHEL 5:* in production and still running.
A LOT have happened since then and I am going to setup Postgres 9+ with everything needed to secure data, backup(PITR)
, cluster with zero dataloss. OS is RHEL 7.2.
I my opinion the documentation is not very straightforward with examples omn exactly how to make such a complete installation using
2+ servers to make data available 24/7. One has to pick up a little here and a litte there. And one always have to do a litte there and here to make things switch
in order to make data available 24/7.
Creating of tablespace can't be scriptet, Restore(I know this another list(pg_rman) can't handle symbolic links.
Sorry about my belching as vocabulary and my bad english!
/Poul