> 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