Re: [GENERAL] Postgres backup solution

2017-03-15 Thread Francisco Olarte
Rich: On Tue, Mar 14, 2017 at 11:42 PM, Rich Shepard wrote: > 2.) I'm far from being a professional DBA but if I had to back up a 13T > database what I'd do (since I use only linux) is run pg_dump with the > archive (tar) format, then use dirvish to synchronize it

Re: [GENERAL] Postgres backup solution

2017-03-15 Thread Stuart Bishop
On 15 March 2017 at 03:04, John McKown wrote: > Your message is not diplaying. At least not for me. I guess that my reader > does not understand the "smime.p7m" file, which shows as an attachment. For > others, his question is: > > === original question from

[GENERAL] Postgres backup solution

2017-03-14 Thread Lawrence Cohan
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

Re: [GENERAL] Postgres backup solution

2017-03-14 Thread Lawrence Cohan
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

Re: [GENERAL] Postgres backup solution

2017-03-14 Thread Rich Shepard
On Tue, 14 Mar 2017, Adrian Klaver wrote: 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

Re: [GENERAL] Postgres backup solution

2017-03-14 Thread Adrian Klaver
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

Re: [GENERAL] Postgres backup solution

2017-03-14 Thread Stephen Frost
Lawrence, First off, I strongly recommend that you figure out how to send regular plain-text emails, at least to this mailing list, as the whole "winmail.dat" thing is going to throw people off and you're unlikely to get many responses because of it. Regarding your question.. * Lawrence Cohan

Re: [GENERAL] Postgres backup solution

2017-03-14 Thread John McKown
lt;pie...@hogranch.com>, "pgsql-general@postgresql.org" < > pgsql-general@postgresql.org> > Cc: > Bcc: > Date: Tue, 14 Mar 2017 15:57:39 -0400 > Subject: RE: [GENERAL] Postgres backup solution > > > -- > Sent via pgsql-general mailing list (p

Re: [GENERAL] Postgres backup solution

2017-03-14 Thread Lawrence Cohan
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

Re: [GENERAL] Postgres backup solution

2017-03-14 Thread John R Pierce
On 3/14/2017 12:31 PM, Lawrence Cohan wrote: Subject: Postgres backup solution From: Lawrence Cohan Date: 3/14/2017 12:31 PM To: "pgsql-general@postgresql.org" was there supposed to be a question or statement or something here ? -- john r

[GENERAL] Postgres backup solution

2017-03-14 Thread Lawrence Cohan
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