Re: how to securely delete the storage freed when a table is dropped?

2018-04-13 Thread Nick Cleaton
On 13 April 2018 at 18:48, Jonathan Morgan wrote: > For a system with information stored in a PostgreSQL 9.5 database, in which > data stored in a table that is deleted must be securely deleted (like shred > does to files), and where the system is persistent even though any > particular table like

Re: how to securely delete the storage freed when a table is dropped?

2018-04-13 Thread Ron
After you drop a table, aren't the associated files dropped? On 04/13/2018 02:29 PM, Ozz Nixon wrote: There are free utilities that do government leave wipes. The process would be, drop the table, shrink the old table space then (if linux based), dd fill the drive, and use wipe, 5x or 8x delet

Re: how to securely delete the storage freed when a table is dropped?

2018-04-13 Thread Ozz Nixon
There are free utilities that do government leave wipes. The process would be, drop the table, shrink the old table space then (if linux based), dd fill the drive, and use wipe, 5x or 8x deletion to make sure the drive does not have readable imprints on the platers. Now what Jonathan mentions -

Re: how to securely delete the storage freed when a table is dropped?

2018-04-13 Thread Steve Atkins
> On Apr 13, 2018, at 10:48 AM, Jonathan Morgan > wrote: > > For a system with information stored in a PostgreSQL 9.5 database, in which > data stored in a table that is deleted must be securely deleted (like shred > does to files), and where the system is persistent even though any particula

Re: how to securely delete the storage freed when a table is dropped?

2018-04-13 Thread Ron
On 04/13/2018 12:48 PM, Jonathan Morgan wrote: For a system with information stored in a PostgreSQL 9.5 database, in which data stored in a table that is deleted must be securely deleted (like shred does to files), and where the system is persistent even though any particular table likely won

how to securely delete the storage freed when a table is dropped?

2018-04-13 Thread Jonathan Morgan
For a system with information stored in a PostgreSQL 9.5 database, in which data stored in a table that is deleted must be securely deleted (like shred does to files), and where the system is persistent even though any particular table likely won't be (so can't just shred the disks at "completion")