Arnaud Lesauvage schrieb:
Tino Wildenhain a écrit :pg_dump does not require you to stop the master database anyway. (in fact it cannot even dump a stopped database :-)Hello Tino, I think I might just use this pg_dump solution... Seems to be quite simple to set up.
personally I think the WAL approach is by far easier to set up and maintain - the pg_dump is in fact easy, but the restore to another database can be tricky if you want it unattended and bullit-proof the same time.
