On 02/24/2018 03:10 PM, Stephen Frost wrote: [snip]
To set up log shipping on 8.4, I do this, which works well:select pg_start_backup('some_meaningful_tag'); nohup rsync -avz /var/lib/pgsql/data/* postgres@${DESTIP}:/var/lib/pgsql/data/ & select pg_stop_backup();That's not log shipping, for log shipping you need to specify an archive_command and actually capture all of the WAL generated, or, at a minimum, the WAL generated between the start and stop backup calls.
That's steps #8, 9 and 10 (in our checklist) of setting up log shipping. Step #4 is configuring the archive_* statements in postgresql.conf.
-- Angular momentum makes the world go 'round.
