So far I have a regression check run that generates a postmaster log that looks like this:
 
LOG:  database system was shut down at 2003-08-02 16:39:48 EDT
LOG:  checkpoint record is at 0/9A0530
LOG:  redo record is at 0/9A0530; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 534; next oid: 17139
LOG:  database system is ready
[db:regression] ERROR:  group "regressgroup1" does not exist
[db:regression] ERROR:  value too long for type character(1)
[db:regression] ERROR:  value too long for type character(4)
.
.
.
[db:regression] NOTICE:  drop cascades to table c1
[db:regression] NOTICE:  drop cascades to constraint p1_a1 on table c1
[db:regression] NOTICE:  drop cascades to table foo column f2
LOG:  received smart shutdown request
LOG:  shutting down
LOG:  database system is shut down
 
At the moment it's forced, so the next thing would be to make it a GUC variable (log_dbname?).
 
Thoughts on format, location of name, etc?
 
cheers
 
andrew

Reply via email to