Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zn6Zw-0004e4-Bg for pgsql-admin@arkaria.postgresql.org; Fri, 16 Oct 2015 15:05:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zn6Zv-0000l7-U2 for pgsql-admin@arkaria.postgresql.org; Fri, 16 Oct 2015 15:05:55 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zn6YG-0005vc-AU for pgsql-admin@postgresql.org; Fri, 16 Oct 2015 15:04:12 +0000 Received: from nm4-vm5.bullet.mail.ir2.yahoo.com ([212.82.96.103]) by makus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zn6YC-0003NR-SA for pgsql-admin@postgresql.org; Fri, 16 Oct 2015 15:04:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1445007846; bh=rQiUMfRVQ3q+y2YQUjQq2H4BWHtsXN+3u0VXsKPQ984=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=dzKUPLK9M/OMfuylUB/r36DtQwqbia74721gXluRApHaE2q7Z1BVw2ly3c8De1NwPdZcL0rL9ftBCew1fXbJ/t2dwZ4Ty/6NyIY9EdGdL2XQYGGLf8eYJsQvCitug8Wua7yh12GaRJoQqW+NyA07inlg5SNyS8oM4VPiykVOlhIJ9PR4m7L+cmjLwdqak8Ge1474E9N7Hbes8sKSarZI8c0QtX/WGfnxHSgIwetTERO0pAY5q7A4kGc6iaP0u3QW1FGYLtuy21HsnwDSaU1/8Hl3Y3C3kjB55pqWWI4LsUvtGMKKvFrPlYl1coqUbf2Jsu4ef5d3qExS1oLclQJc7g== Received: from [212.82.98.61] by nm4.bullet.mail.ir2.yahoo.com with NNFMP; 16 Oct 2015 15:04:06 -0000 Received: from [212.82.98.111] by tm14.bullet.mail.ir2.yahoo.com with NNFMP; 16 Oct 2015 15:04:06 -0000 Received: from [127.0.0.1] by omp1048.mail.ir2.yahoo.com with NNFMP; 16 Oct 2015 15:04:06 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 733861.62241.bm@omp1048.mail.ir2.yahoo.com X-YMail-OSG: 3QLyS08VM1mc0oH2oCNhbWS9My7pPi9JVgojQzRIBC0xO4JPlDKTtew6A5uQmvY WIexgfUJqaD4PSIKfcvlkFOqozyKhuKBjmUE6UBYfGXrKMlaBVP2kKi697IjcTaLzMFxOPwJxlBA iRWRSb5mdQ65G1TMXfdsHE7tV25jFigfbJuoYMkzfohCuYtM1PFdBE3aJmw5qs.MP8p2HjRf03gP 7yKMcTzDhWC4AgPV0fYoJsl7M_ax1Yvj9.NX2a5zYVUhV3ABK0j9j.7RgEsxuse0whzAEo3wx7sa e.4JKxREHaEeIzFkLGipRojK4s9zq.rlDTPeR_z5UtcTf17gK5LEDVNSm.1n9gFsi.5d6NNV8X06 VQVhzhOm1rkJAFasXyH26eAsNZrE.WqQrMW0PAN7mHtxlEgt52nc2Q4HFplMN_yDIp8jFiCiZGYG DsryxhmxpeKE2p0E920PFfPbE_5jD5VXEfS_m01G7JhwFQTDYLpla.36MLkqd36ir5RnvjsHL5u_ j840LkDywYCpLPrj. Received: by 212.82.98.122; Fri, 16 Oct 2015 15:04:05 +0000 Date: Fri, 16 Oct 2015 15:04:05 +0000 (UTC) From: Glyn Astill Reply-To: Glyn Astill To: Mark Steben , pgsql-admin Message-ID: <1389654171.2209747.1445007845293.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: Subject: Re: method of encrypting backups MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Length: 629 X-Pg-Spam-Score: -1.3 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > From: Mark Steben >To: pgsql-admin >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