Re: pg_update to a new machine?

On 02/24/2018 06:40 PM, Stephen Frost wrote:
> Ron,
>
> * Ron Johnson (ron(dot)l(dot)johnson(at)cox(dot)net) wrote:
>> 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(at)${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.
> I would still recommend you use a tool developed specifically for taking
> proper PG backups which validates that all WAL generated during a backup
> is properly archived, such as pgBackRest, which also makes sure to sync
> all the data out to persistent storage and can also operate in parallel
> and perform incremental restores.

OK.  I'll try to get it installed.  (Lots of paperwork, etc.)

--
Angular momentum makes the world go 'round.