| 场景 | 日志大致内容格式 | 日志级别 |
|---|---|---|
| 实例启停 | the database system is shutting down | FATAL |
连接中断 | terminating connection due to administrator command | FATAL |
| terminating connection due to unexpected postmaster exit | FATAL | |
| terminating connection due to immediate shutdown command | FATAL | |
| connection to client lost | FATAL | |
SQL 语法解析出错 | syntax error at or near xxx | ERROR |
| division by zero | ERROR | |
| function xxx does not exist | ERROR | |
| function with OID xxx does not exist | ERROR | |
| column xxx does not exist | ERROR | |
| column xxx of relation xxx does not exist | ERROR | |
权限相关错误 | password authentication failed for user xxx | FATAL |
| permission denied for table xxx | ERROR | |
| permission denied for function xxx | ERROR | |
| role xxx does not exist | FATAL | |
| role with OID xxx does not exist | FATAL | |
资源不足 | out of memory | ERROR |
| could not write to file xxx | ERROR | |
| could not open file xxx | ERROR | |
| could not create shared memory segment: xxx | FATAL | |
数据完整性问题 | item order invariant violated for index: xxx | ERROR |
| can't find left sibling high key in index | ERROR | |
| duplicate key value violates unique constraint | ERROR | |
| null value in column xxx violates not-null constraint | ERROR | |
| foreign key constraint cannot have xxx columns | ERROR | |
| foreign key constraint xxx cannot be implemented | ERROR | |
| foreign key constraints are not supported on foreign tables | ERROR | |
事务相关问题 | could not serialize access due to concurrent update | ERROR |
| could not serialize access due to concurrent delete | ERROR | |
| invalid transaction termination | ERROR | |
| deadlock detected | ERROR | |
| current transaction is aborted xxx | ERROR |