Re: Postgres backup solution

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Lawrence Cohan <LCohan(at)web(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres backup solution
Date: 2017-03-14 22:30:02
Message-ID: 0af7d76b-9c38-59de-4f13-a6881de49796@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 03/14/2017 01:58 PM, Lawrence Cohan wrote:

Cut-and-paste from winmail.dat:

"Let's try this one more time in plain text and please note that I'm
creating the email totally in plain text, and send as plain text.
Unfortunately I have no control on the mail server if that's where this
message gets mesed up and flipped from plain text to something else.

What would be a recommended solution for backing up a very large
Postgres (~13TeraBytes) database in order to prevent from data
deletion/corruption. Current setup is only to backup/restore to a
standby read-only Postgres server via AWS S3 using wal-e however this
does not offer the comfort of keeping a full backup available in case we
need to restore some deleted or corrupted data.

Thanks,
Lawrence Cohan"

Still not coming through as plain text. You might want to talk to
whoever is in charge of the email server.

>
> ________________________________
>
> Attention:
> The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies.
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-03-14 22:40:27 Re: UPDATE ... ON CONFLICT DO NOTHING
Previous Message Lawrence Cohan 2017-03-14 20:58:58 Postgres backup solution