Re: [ADMIN] insert OS command results into a table on a remote system ?

2010-06-09 Thread Tim Landscheidt
Kevin Kempter wrote: > I want to gather OS command based stats such as the results of commands > like: 'df' 'iostat' 'free' etc and put the results into a temp table that I > can then select from. > I need to do this all from the db since I wont have OS/shell access, > only 'psql -h' access. Is

Re: [ADMIN] Database level encryption

2010-04-07 Thread Tim Landscheidt
Timothy Madden wrote: > [...] > User authentication should be unrelated to encrypting the database > owned by that user. You can think of it as if only the owner can ever > connect to such a database, and his/her password is the encryption > key, or as if any user that wishes to connect should pr

Re: [ADMIN] Database level encryption

2010-04-06 Thread Tim Landscheidt
Timothy Madden wrote: > The machine does not have internet and it will not be trivial for the > bad guy to install anything there. > [...] Then why bother encrypting the database if $BADGUY cannot access it without your installed application anyhow? Tim -- Sent via pgsql-admin mailing list (

Re: [ADMIN] insert a backslash into a bytea field?

2009-08-11 Thread Tim Landscheidt
Kevin Kempter wrote: > we want to insert a single backslash into a bytea column (running postgres v > 8.3.5) > this works to insert 2 backslashes (but we only want one): > insert into test_bytea_tab (id, bytea_test_col) > values(99, 'testdata'::bytea) > [...] This inserts a single backs