Re: Postgres Point in time Recovery (PITR),

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: Postgres Point in time Recovery (PITR),
Дата
Msg-id CAKoxK+7PpV6G16nuXhuUjUN_SNVjUsVM2s5ns_AMUvksgys52A@mail.gmail.com
обсуждение исходный текст
Ответ на Sv: Postgres Point in time Recovery (PITR),  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Re: Postgres Point in time Recovery (PITR),  (David Steele <david@pgmasters.net>)
Список pgsql-general
On Fri, Oct 18, 2019 at 10:30 AM Andreas Joseph Krogh
<andreas@visena.com> wrote:
> We use barman (https://www.pgbarman.org/) for continuous streaming backup and I had to restore from it once, and it
wentlike this:
 

Just for the records, here's an example of restore with pgbackrest:

% sudo -u postgres pgbackrest --stanza=miguel \
       --log-level-console=info --delta restore
...
INFO: restore backup set 20190916-125652F
INFO: remove invalid files/paths/links from /postgres/pgdata/11
INFO: cleanup removed 148 files, 3 paths
...
INFO: write /postgres/pgdata/11/recovery.conf
INFO: restore global/pg_control (performed last
                to ensure aborted restores cannot be started)
INFO: restore command end: completed successfully (5113ms)



В списке pgsql-general по дате отправления:

Предыдущее
От: Олег Самойлов
Дата:
Сообщение: Re: stable for each row before insert trigger
Следующее
От: Patrick FICHE
Дата:
Сообщение: Execute a function through fdw