On Fri, Oct 16, 2015 at 11:04 AM, Glyn Astill <glynastill@xxxxxxxxxxx> wrote:
> From: Mark Steben <mark.steben@xxxxxxxxxxxxxxxxx>
>To: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
>Sent: Friday, 16 October 2015, 15:09
>Subject: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
