pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmethod of encrypting backups
3+ messages / 3 participants
[nested] [flat]
* method of encrypting backups
@ 2015-10-16 14:09 Mark Steben <mark.steben@drivedominion.com>
2015-10-16 15:04 ` Re: method of encrypting backups Glyn Astill <glynastill@yahoo.co.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Mark Steben @ 2015-10-16 14:09 UTC (permalink / raw)
To: pgsql-admin
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 <http://www.autorevenue.com/; | Autobase
<http://www.autobase.net/;
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 <http://www.autorevenue.com/;
<http://autobasedigital.net/marketing/DD12_sig.jpg;
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: method of encrypting backups
2015-10-16 14:09 method of encrypting backups Mark Steben <mark.steben@drivedominion.com>
@ 2015-10-16 15:04 ` Glyn Astill <glynastill@yahoo.co.uk>
2015-10-16 15:46 ` Re: method of encrypting backups Scott Mead <scottm@openscg.com>
0 siblings, 1 reply; 3+ messages in thread
From: Glyn Astill @ 2015-10-16 15:04 UTC (permalink / raw)
To: Mark Steben <mark.steben@drivedominion.com>; pgsql-admin
> 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: method of encrypting backups
2015-10-16 14:09 method of encrypting backups Mark Steben <mark.steben@drivedominion.com>
2015-10-16 15:04 ` Re: method of encrypting backups Glyn Astill <glynastill@yahoo.co.uk>
@ 2015-10-16 15:46 ` Scott Mead <scottm@openscg.com>
0 siblings, 0 replies; 3+ messages in thread
From: Scott Mead @ 2015-10-16 15:46 UTC (permalink / raw)
To: Glyn Astill <glynastill@yahoo.co.uk>; +Cc: Mark Steben <mark.steben@drivedominion.com>; pgsql-admin
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
http://openscg.com
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-10-16 15:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-10-16 14:09 method of encrypting backups Mark Steben <mark.steben@drivedominion.com>
2015-10-16 15:04 ` Glyn Astill <glynastill@yahoo.co.uk>
2015-10-16 15:46 ` Scott Mead <scottm@openscg.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox