| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Table update: restore or replace? |
| Date: | 2019-05-14 21:05:58 |
| Message-ID: | f03ea12f-2d98-33ea-9f98-cc93f06aff97@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/14/19 1:59 PM, Rich Shepard wrote:
> On Tue, 14 May 2019, Adrian Klaver wrote:
>
>> A file level backup or database dump?
>
> Adrian,
>
> File level. April 20th is my most recent database dump because I forgot to
> run it last Friday afternoon.
Does the table you overwrote the data change much?
If not it might be safer to just fetch it from the April 20th dump and
then apply the changes since then.
If you where to restore at the file level I would:
1) Stop the server.
2) Move the existing content of /var/lib/pgsql/10/data/ somewhere else
just to be safe.
3) Copy in the backup.
>
> Rich
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-05-14 21:10:39 | Re: Table update: restore or replace? |
| Previous Message | Rich Shepard | 2019-05-14 20:59:18 | Re: Table update: restore or replace? |