Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jxVmK-0001c6-Q5 for pgsql-admin@arkaria.postgresql.org; Mon, 20 Jul 2020 13:24:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jxVmJ-00046R-KM for pgsql-admin@arkaria.postgresql.org; Mon, 20 Jul 2020 13:24:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jxVmJ-00046K-9j for pgsql-admin@lists.postgresql.org; Mon, 20 Jul 2020 13:24:23 +0000 Received: from mail-wr1-x444.google.com ([2a00:1450:4864:20::444]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jxVmG-0001Gc-Mg for pgsql-admin@postgresql.org; Mon, 20 Jul 2020 13:24:22 +0000 Received: by mail-wr1-x444.google.com with SMTP id a15so2893100wrh.10 for ; Mon, 20 Jul 2020 06:24:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=2J92dyFKkVQoFm/rsB2PCbJwFhjNL4gZkS6tcapPLsU=; b=IINBtHwG2TSwFf3IZ9jFfZZTwbaKTQeJNxjpiQnHU/QCcydSMl44vYKt78havqIsDy 1ZaxseUjHdPPoxf+61YnR8YsCvD9Rl8/A+kwBbDunMR6WqYQ4JS6z7gFZwyVIRfFAChy WAWBphqn0Qc8lr572MIqbdjR8y4fdiCC+PqUG9dHkmps6AZi+fQx/WzyhKx6P14uEUzU uxo2tB9H6SjuUOPHEJcztAGg1x9cxG+MCBHxmBI7yhFkyqq+PylMo8fKLpp9e5++MCbn 4TF+lhSiCN4CuOTZwIDk/+4PDsMaoaq757sEP/UzRZLbZJE4OZ2ENsCmEu3EOIMnyXb8 Bmxg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=2J92dyFKkVQoFm/rsB2PCbJwFhjNL4gZkS6tcapPLsU=; b=U2wO9253/BxodvruaaCI1aJrkds0CKcIWRdHP9ds93S69D3zMWta1wm/D967lCCVxM Kyj5c43LeA2coy2p8Rmsq21oBWjuPEIXRaP1OeVrT0RrkLgo7G6yCbFUWo9VPBpfifFm /qNUmKmF6eVb90VkRvUfjMWCTWBPM2jkuEWeJwf/2x3GPDptasE9yFs6OL+kY7x1LERQ BeUHgY4iVI4yhGFu2D+TDia/t3gwKZz6/nhX+Vb5KOYpk9cWPwpGXOYLz/it7iPZSyDB txie/jHV7e5qCV0a2lmoIUiVs2mts7Byj0MXwmCNeV6S4QEi3Sl5SVyLYKoVDsT/FRDv F4Dg== X-Gm-Message-State: AOAM531W7jkilR9wg8mljzzRGaqsEuRqkC1UsXi1O4/hiBdVkLeF68ar 7mlMlyzqze7JzlFyKd0UyVQ= X-Google-Smtp-Source: ABdhPJyKDoI6+344YYLE6pmd1DrFtyQtH3KnPXt5lOsmz3fWV0va6Vs6K2zAKTNspKjHjUTqsGvlMw== X-Received: by 2002:adf:9307:: with SMTP id 7mr21764830wro.414.1595251459482; Mon, 20 Jul 2020 06:24:19 -0700 (PDT) Received: from [192.168.1.8] (241-57-239-77.dyn.cable.fcom.ch. [77.239.57.241]) by smtp.gmail.com with ESMTPSA id 5sm30838447wmk.9.2020.07.20.06.24.19 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 20 Jul 2020 06:24:19 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.1\)) Subject: Re: Encryption in pg_dump From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: Date: Mon, 20 Jul 2020 15:24:16 +0200 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <2BCA8D4B-E94D-4F2F-99A5-D783912A1CDF@gmail.com> References: To: vinod kale X-Mailer: Apple Mail (2.3608.120.23.2.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Vinod, > On 20. Jul, 2020, at 14:40, vinod kale wrote: >=20 > Hello Team,=20 >=20 > I am using postgresql 10.8 version in our prod environment. We take = dump backup on daily basis of full database. And this dump backup = creates in human readable format.=20 > My requirement is backup should creates in encrypted format at the = time of pg_dump running.=20 > Is there any way or any option available in pg_dump that will creates = the backup in encrypted format or any tool available for same. sorry, no way. The only way you have is to pipe the output of pg_dump = through some encryption tool. pg_dump does not offer to create encrypted = dumps directly using some command line option. Cheers, Paul