Re: [GENERAL] Use a blob or not?

2009-12-07 Thread Colin Streicher
On December 7, 2009 12:07:49 pm Daniel wrote: > I want ot store chunks of data (only about five Kb each) on a database > and have users download (across a network) these chunks to their local > disk drive. Is a blob a good way to store these chunks? > > Thanks. > Put me on the list of recommendin

[GENERAL] Postgres security article

2009-11-28 Thread Colin Streicher
FYI I thought it was a good read, hope someone else finds it useful http://www.ibm.com/developerworks/opensource/library/os- postgresecurity/index.html Colin -- You own a dog, but you can only feed a cat. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] bytea corruption?

2009-08-23 Thread Colin Streicher
I'm probably a little late to this discussion, but I have had issues before with BYTEA in postgres before as well, this is what I found worked. use Digest::MD5; use DBI qw(:sql_types); use DBD::Pg qw(:pg_types); sub InsertBin($$$) { my ( $dbh, $md5sum, $filename ) = @_;

Re: [GENERAL] Connect to server PG from laptop java app

2009-04-05 Thread Colin Streicher
Also, I don't know if this applies to windows systems, but on linux systems you have to also modify postgresql.conf On my system, it is in the same directory as pg_hba.conf looks like this: #-- # CONNECTIONS AND AUTHENTIC