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

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

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

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

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

> 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

Re: hardcode password in connect string

PGPASSWORD env var works fine. Thanks ! On Fri, Apr 13, 2018 at 2:46 PM, James Keener wrote: > Is setting it as an environment variable an option? > https://www.postgresql.org/docs/9.1/static/libpq-envars.html > > Alternatively, a service file? https://www.postgresql.org/ >

Re: hardcode password in connect string

On 04/13/2018 12:46 PM, James Keener wrote: Is setting it as an environment variable an option? https://www.postgresql.org/docs/9.1/static/libpq-envars.html Alternatively, a service file? https://www.postgresql.org/docs/9.0/static/libpq-pgservice.html Jim On April 13, 2018 2:43:01 PM EDT,

Re: hardcode password in connect string

Is setting it as an environment variable an option? https://www.postgresql.org/docs/9.1/static/libpq-envars.html Alternatively, a service file? https://www.postgresql.org/docs/9.0/static/libpq-pgservice.html Jim On April 13, 2018 2:43:01 PM EDT, David Gauthier

hardcode password in connect string

Hi: PG v9.5.2 on RHEL I like to use an alias to connect to my favorite DBs but don't like to enter passwords. I used to just disable passwords (working behind a firewall), but this one is different. I see nothing in the interactive connect string where I can enter the password... psql -h

Re: Recursive CTE for building menus

On 13 April 2018 at 16:04, Paul Jungwirth wrote: > On 04/13/2018 02:09 AM, Bob Jones wrote: >> >> The adaptions I am trying to make are as follows: >> - Higher priority moves the item higher up the menu (i.e. adapting >> from the original "votes" concept). >> -

Recursive CTE for building menus

Hello, Whilst researching current thinking on hierarchical queries in Postgres, I stumbled accross this excellent blog post: https://illuminatedcomputing.com/posts/2014/09/postgres-cte-for-threaded-comments/ But try as I might, my SQL-foo is not up to scratch to adapt it to my needs, I keep on