I back Postgres DB 9.1 up using following command:
pg_basebackup -h 127.0.0.1 -U replicationuser -D /storage/test_backup -Ft -z -P
In postgresql.conf I have this set:
wal_level = hot_standby
However, at the end of
pg_basebackup run I get this warning:
NOTICE: WAL archiving is not enabled; you must ensure that all required WAL segments are copied through other means to complete the backup
I care about the backup of data from time of starting
pg_basebackup only (I can afford a bit of downtime in the night, so I shut down the app server that is using this PG instance as backend DB and then start the backup). I do not need nor aim to have "continuous backup".
Question: do I really have to copy the WAL to have complete backup from the time of starting
pg_basebackup command? Or is that warning designed strictly for purpose of achieving "continuous archive" functionality?