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

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Table update: restore or replace? [RESOLVED]
Date: 2019-05-14 23:35:07
Message-ID: alpine.LNX.2.20.1905141632450.30120@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2019-05-15 00:08:51 Re: Table update: restore or replace?
Previous Message Rich Shepard 2019-05-14 22:14:40 Re: Table update: restore or replace?