Re: Table update: restore or replace? [RESOLVED]

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Table update: restore or replace? [RESOLVED]
Дата
Msg-id alpine.LNX.2.20.1905141632450.30120@salmo.appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Table update: restore or replace?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Tue, 14 May 2019, Adrian Klaver wrote:

> Or just fetch them from the table data you have saved in the dump file.

Adrian,

This did save a lot of time! Thanks for the pointer.

>> And I think I'll set up a cron job to do a database dump each day with the
>> date appended to the file name in the bash shell script.

> Yeah, that will save a lot of heartburn:)

Done. Cron will run the shell script at 02:15 each day. This will do until I
build, install, and configure pgBackRest (which consumes less disk space
than do the daily pg_dumpall files.

Best regards,

Rich



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

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Table update: restore or replace?
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Table update: restore or replace?