Re: method of encrypting backups

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

>
> > From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
> >To: pgsql-admin <pgsql-admin(at)postgresql(dot)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

http://openscg.com

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