Forgive me for the ignorant question, but I see postgres has their WAL logs, and there are talks about using filesystem snapshots, and the WAL with the snapshots may or may not be sufficient backup/recover...I'm not traditionally a DBA/admin (I'm a developer), but reaching a point where looking to get better at supporting these needs.
Question: Can Postgres be setup on a 10GB or 100GB sized system to not use special backup software, but instead just use traditional filesystem backup software (filesystem snapshots?) and has a reasonable method of recovery using this method? (if sizing matters, would like to know)
Usecase 1: to avoid special backup approach when using Postgres and just use normal file system. No downtime, or < 5 seconds.
Usecase 2: When used with a hybrid ECM, such as Alfresco, where the file system contents (images) and the metadata (database) should always be backed up and restored in unison. No downtime, or < 5 seconds.
Please elaborate on areas I may not be asking, such as good/bad ideas or things to watch out for :-)
(note, this is for local install on linux environments, if particular filesystem is needed for a strategy, that is fine).