Subject: Re: Secure dump file
To: ilyassikai@gmail.com, pgsql-admin@postgresql.org
References: 
 <CAMmziWdWzojpwfgbPVG1hmH+j79WxZyZ9mxorELLhpY=n-T+=g@mail.gmail.com>
From: Joe Conway <mail@joeconway.com>
Openpgp: preference=signencrypt
Autocrypt: addr=mail@joeconway.com; keydata=
 xsFNBEpXMCsBEADDnXUQzjlyi/cX02Gtdy2CLcroE5CsC7DJKdOBDbfgn0kfiIYoV5JniG4l
 VyzZUodY8yUAagqLYolh0UkBzs9N+qkm7erde4ypw3jzVQ37BuzIvk3nMUbuDZDgxWqX+nVS
 sKc+BQ5BpzgCHg48leoRO2ohjvYnUhgH3j2rFZCzaj6qQ7mv+XoxOJmUlVQtG06Jwkk7Vu14
 7U9nMMM6hyUKzVnmCphnlcMNo26UyVU70MwFfFJgcI0c5fpp8byN56eD6VJVnufO5WAuEhzE
 qcrSJR2FAlmM90GBY+6vP29twLDCHuSFvrnujNCx/BvCC/a3/gPvyAFp4JtMm9eXAmq3m/Kw
 94nTJXVdcbQeQQDp3KIG7MmWS4lnGvPn8v0CjgNaLvZXFLo1FgmUVsyEq1Lww4iRLa6sbpXJ
 ESx15UEue1k1YZM9C+4F/o3aeKNsAienjw2EXFzcaxIg/C4P493VMi3Qa8ycVxR5iYhUbYdo
 DFIUQhbFNsYfrtW/qZAELT3FCYFpZYG01e9Hj+cBrXXgyDDkQ5Lq4mlvmkRvuxn61V6Au4HA
 0sJiCox5pM1FvzT+aI8HY1BYaiB9Pl4fhpKgmhhlSuglk9v39S4jmlUIb45iLAUVpeNM6Qjm
 69pf5da9sm4aGFa7YlDSKf/WcU7z9ITZxsilOi2n7YJiwG7kTQARAQABzR9Kb2UgQ29ud2F5
 IDxtYWlsQGpvZWNvbndheS5jb20+wsF8BBMBAgAmAhsDBwsJCAcDAgEGFQgCCQoLBBYCAwEC
 HgECF4AFAlpoksUCGQEACgkQMyt+aLaZQ0p4XQ/9F4WSf4ZFuL3ae356ApVqnLxphHXeXHli
 ePZe7qosvXMQLN9Y2m5cQwqojsQh4pZujIi4Iwxw7ORg6HbMO8dMhyu8TlDavErcgO561hG7
 /TCcCLf5SkadxBqYWAJH09W8S2iC3gQtS+qs4Y7sIvRi881EsPzG5Lrzu7Ei8ufqsSnbLUQk
 zAaKjK3IzAFvzA3VCg/8Aqhf8obhqL0j5I5DNOpAt2U4gkEzIrX1g5xSXpRLMHLEK7hPViY8
 pFQyRvyZioE4hckNsnidCgiv4HefJUFRIVxDkHBeLhTzqTPloesFT/bskhckIS6F4suMx044
 WTTW6UiARuWw3aaBTmxay2rjPCsGaJPawzY0O3HlNlZherCzuBpa+Qk1kMLkcxMlYjCrMgIR
 YyBpIK46ltPQaog4Ujh21w1Z8m/ufG5v/HTuLdXM9hGfTlW7aY6psCAV/MwfycDHLRMc+UY7
 W2cp6DlWQ7GHLP+vzvBcl5Odi04EhcYnHMZjKvRFsxhE0LZcTejrtxPkDgR9G59irlIx1+py
 ziK2B0hs7Er1Yq7qQGQiQGLoglSNDsvsUeyMGyabasmUd5xrRO35SpGv+hyYGAZ3Pyk9Vtxl
 CO7BJkZiV9YSMHp6hOdmYZd4SZRChd9sKd6eSw1xIlBALz1ZHuQVMBuZvuVGFsS81Zqckb/2
 D5rOwU0ESlcyJwEQAOkTBb9yDhJbMUgvhM11rZwT5tm4Y9TqtEHn0Zy3t9g7bdFFpMvav/KE
 Nd3oAtLFpMDf+H3AggFk4ftUwJwiVgJ88ilvCynJUGXiuYIaexY4DLgn4xpnuiEpYEFVdWnl
 w7dWVTc62exfqIz9bSWRzwfBCY9ruYGEb4RDPDSNSAVyI7sxHzef2asiYxIcxrTrw5VugWNl
 PZcV5/EJ6PUvATjBF2TBkXV7KOciQng2tsQGrGMkY5mduNqwpuh6zfPcVF8LeObe96wv5ZhP
 RpO79nef7hnK2lJogp3JIo558Jlbz9WHtQEMZR85+bUhtI825QyNAFz3Jrn7NMgvDikc2OrW
 o7YMgMC5hDSWVFqA6/EQCNnDWGABWgeYHZFpnPwsvUWIYdhSilUuj/Tuzvz9ZmucFNbQbauD
 Qw6VQ38ofGnoYDZFJsGncprB8dBi4tDrIQ+1RlIh6C2Z/eMipqJOT26+spluTjouvnKT0S5y
 OgyX0PjbsysgwQdCGNJLHOjhHbSpSmOLaduV3CQo/0+DHT/TBjYfIXjTWouY9TkGxG4eNrxU
 0u2xAy5bMqOPmsFdjLTWlQUlF/fTMhB54XwI3FHWgnSnXZzStDTmTebLNdT/ftgliAzA81uM
 j49j0exv731/v+7udLA1bV8gnZ01zQCASDpWiRQR3fgwcugSUqgRABEBAAHCwV8EGAEIAAkF
 AkpXMicCGwwACgkQMyt+aLaZQ0pwAQ//bjcWnZg/jjRQ9gbZUGMqniItZYRglBMKIqt4Fia3
 79JmHwTvavnFkJ8XMZ56UB0FIrgS+sUkRH6cPRQR+7Qi392LD021DXgSsz9CwFHjFyBGHwLE
 OTRcfYQbtJy0shHDJB4aQTOX3ERDH1PsvJNuevmQMzS0DWFav9+xMz9rKP4N+HffoBIZE0C1
 xIE43nD4eLsbycte9sVIrmlNuUti3qUxJAQw8HwfJ6ZbBInHxquApR16uD1u99o6XlndFrDl
 Y22tRmHCM0bR81GfGNdcU3Uo+rG/R/k4qa7s9/dgKvMbyH3fHhp/ceKag80Xo8IFurRl0ZJP
 3sHJ2QDHCVLat7jRZ+43hi1WlIhFbrgn6IyI0i7XR/W8JjrC5MsKq4TUwGH077sU/kcHYebV
 JZRbUUst2hAGHDFVBcG12qoKf+ltL9qXJc1y7BGeCoUW6QjOpljpq6ZL4FQUsM0RSRjs5egE
 3szPcIf5SyPK6WDOApoAq6M7BBFMGDZwEylYMtr0YekA1u86UA9D2xwLHEbBBp/uiby1c9Jb
 PJ1Pn8zJP8WZNeRw4Q9TtqVK09+oLirMUSpIDd6KdZ1VgRxOK2re7tjDvkVuYsSrsiJ+1iJN
 Enp9iK0ok0DlJpSCe6KhkxpaTdeoWMXdKuJWec0NIqoAd54ZgBPnr+UPxTixgPq/p6Q=
Message-ID: <9de9b0f3-e632-8ea4-e474-d687a2a17185@joeconway.com>
Date: Mon, 13 Aug 2018 15:14:09 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: 
 <CAMmziWdWzojpwfgbPVG1hmH+j79WxZyZ9mxorELLhpY=n-T+=g@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="60p6MZtS1ytzxhaXkYo79VMg0RwLgFaB7"
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--60p6MZtS1ytzxhaXkYo79VMg0RwLgFaB7
Content-Type: multipart/mixed; boundary="roeP0EzCHAXwRX0oqeczRMhXcid9Imlbj";
 protected-headers="v1"
From: Joe Conway <mail@joeconway.com>
To: ilyassikai@gmail.com, pgsql-admin@postgresql.org
Message-ID: <9de9b0f3-e632-8ea4-e474-d687a2a17185@joeconway.com>
Subject: Re: Secure dump file
References: <CAMmziWdWzojpwfgbPVG1hmH+j79WxZyZ9mxorELLhpY=n-T+=g@mail.gmail.com>
In-Reply-To: <CAMmziWdWzojpwfgbPVG1hmH+j79WxZyZ9mxorELLhpY=n-T+=g@mail.gmail.com>

--roeP0EzCHAXwRX0oqeczRMhXcid9Imlbj
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: quoted-printable

On 08/13/2018 02:53 PM, Ilyass Kaouam wrote:
> I have a database server in which I save the database (dump) in a
> directory (let say /home/backup)

> I would like to monitoring all the dump in this directory and know if
> some one make a cp or mv or...
> Any idea ?

Your best bet is probably to use pgbackrest - see:
https://pgbackrest.org/user-guide.html#quickstart/configure-encryption

HTH,

Joe

--=20
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


--roeP0EzCHAXwRX0oqeczRMhXcid9Imlbj--

--60p6MZtS1ytzxhaXkYo79VMg0RwLgFaB7
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBCAAGBQJbcdiBAAoJEDfy90M199hl4KQP/2vKbgoedp+LFXSF1SGvskPw
axDF1hQ9n/3sbv+6e0TAq9pBBP6zX3akrQH65/OfdPuq1VJj+A4+JDm5noWnCgBu
JwefxZBcIdyEUiv7jK25ysrDUhWXTPbweuswggEPnbqanAzpbPk8/dYMsIgT2ZZm
oHiQWv+vwcGpWCMxXMdz8vbJ2iQ4rojk7Vmk8Z0EijDPhQxiVCSOUvCQsGTT53ff
6drtr4abgopPcQ/KYmy55tSmYX75v2rnXpQfSj1M1Gv+A/POB6C+qICYINN53C+T
KEmjqkMA+COhQJDehV8qFGIUOylQoXzD/Oj7VyyzzlPQmic8DjZ6CYAOC/sZGdyF
fYmUFfG1VBgdfpSVGUmu6mBjiHS1KUZ8efNGDPb9BDG4l2SG9hWZvWdbm4bFZclp
k5ZcU/Z/DgfM25SujuxQ+R2TTli7vwR3uveBl1JSOoI8Oww2c3Icasa/s/MwEFsk
SDD8BGq4Q71i8CAhbihwT8o/h3nT7BZvFRSY0RDUJl1l1blPVbFO8nA5IAOhlMDD
letn6keP4b/GBp8PTXGXwVdITD5j/YAZGyI6Sb7mRSxCDpeEwazQPiasjKDMpVYR
VHcBSTn0ly5LZiCCJqJcmEG/Q4nkk6G+Xrx3YV8bdx1SrNinCVv7siA0jHdIrm4z
G0/f2V6MSO0tIhpmqsIt
=v+fe
-----END PGP SIGNATURE-----

--60p6MZtS1ytzxhaXkYo79VMg0RwLgFaB7--