copy / backup question - copying a data directory while the db is shutdown - Mailing list pgsql-admin

From CS_DBA
Subject copy / backup question - copying a data directory while the db is shutdown
Date
Msg-id 5330B5DD.7030805@consistentstate.com
Whole thread Raw
Responses Re: copy / backup question - copying a data directory while the db is shutdown  (Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>)
List pgsql-admin
Hi All;

If I shutdown a HOT standby slave (via the -m fast command) can I then
copy the data directory to a "backup" location and be guaranteed that
the backup copy will start?

For some reason I thought there were issues (or potential issues) with
this method and a PITR based recovery approach was a better guarantee
that the copy will start


Thoughts?



pgsql-admin by date:

Previous
From: Jason Mathis
Date:
Subject: archiving wal files after PITR
Next
From: Евгений Селявка
Date:
Subject: Re: VIP Manager?