Postgres Pro
Downloads
Home   >   mailing lists

Re: method of encrypting backups - Mailing list pgsql-admin

From Scott Mead
Subject Re: method of encrypting backups
Date
Msg-id CAKq0gvJqz18MzCetwqoEE7P-iFn9ZYwmFV9f0y_odqrkyX-3Yw@mail.gmail.com
Whole thread Raw
In response to Re: method of encrypting backups  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-admin
Tree view

On Fri, Oct 16, 2015 at 11:04 AM, Glyn Astill <glynastill@yahoo.co.uk> wrote:

> From: Mark Steben <mark.steben@drivedominion.com>
>To: pgsql-admin <pgsql-admin@postgresql.org>
>Sent: Friday, 16 October 2015, 15:09
>Subject: [ADMIN] method of encrypting backups
>
>
>
>Good morning,
>
>We are running postgres 9.2.12 on linux Centos operating systems.
>We currently use pg_dump to back up specific databases off a slony replicated server.  We use custom formatting suitable for pg_restore.
>
> We also run a weekly tar from production to back up all our clusters.
>
>Is there a recommended method of encrypting one or both of these backup types?
>


Not sure about a recommended method, but I use ccrypt.

I would pipe the output through some time of encryption tool, personally, I like gpg, but, it's probably a bit expensive

pg_dump -F c ...... | gpg .... > backup.dump.gpg


--
Scott Mead
Sr. Architect
OpenSCG
PostgreSQL, Java & Linux Experts

 


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Glyn Astill
Date:
Subject: Re: method of encrypting backups
Next
From: HEMPLEMAN Matthew
Date:
Subject: Locking: PostgreSQL Vs. Oracle