Re: Table update: restore or replace? [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: Table update: restore or replace? [RESOLVED]
Date
Msg-id alpine.LNX.2.20.1905141632450.30120@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Table update: restore or replace?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Table update: restore or replace?
Next
From: Stephen Frost
Date:
Subject: Re: Table update: restore or replace?