Обсуждение: method of encrypting backups

Поиск
Список
Период
Сортировка

method of encrypting backups

От
Mark Steben
Дата:
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?

Thank you,

--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com





Re: method of encrypting backups

От
Glyn Astill
Дата:
> 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
suitablefor 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.

Re: method of encrypting backups

От
Scott Mead
Дата:

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