[Snort-users] postgres schema error
Martin A. Brooks
martin at ...9044...
Mon Apr 28 09:39:06 EDT 2003
I've been attempting to install snort on a Debian system and have it log to
postgres. I had a look at the schema before creating the tables and I
CREATE TABLE schema ( vseq INT4 NOT NULL,
ctime DATETIME NOT NULL,
PRIMARY KEY (vseq));
Postgres 7.3.2 does not have a DATETIME data type, I believe it uses
"timestamp" instead. So a simple :%s/DATETIME/TIMESTAMP/g cosmetically
fixes the problem.
Would anyone care to confirm/deny this is the case?
Martin A. Brooks, Clues Ltd
More information about the Snort-users