| PostgreSQL 9.6.0 锟街诧拷
| |||
|---|---|---|---|
| 锟斤拷一页 | 锟斤拷一锟斤拷 | 锟斤拷 19. 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 | 锟斤拷一页 |
PostgreSQL支锟街讹拷锟街凤拷锟斤拷锟斤拷锟斤拷录锟斤拷锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷stderr锟斤拷csvlog锟斤拷syslog锟斤拷锟斤拷 Windows 锟较伙拷支锟斤拷eventlog锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿伙拷锟斤拷锟斤拷锟揭拷锟斤拷锟街灸匡拷牡氐锟斤拷斜锟斤拷锟街拷锟斤拷枚锟斤拷欧指锟斤拷锟侥拷锟街碉拷锟街伙拷锟铰硷拷锟�stderr锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟�csvlog锟斤拷锟斤拷锟斤拷锟斤拷log_destination锟叫ｏ拷锟斤拷志锟斤拷锟斤拷锟�"锟斤拷锟脚分革拷值" 锟斤拷CSV锟斤拷锟斤拷式锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷院芊锟斤拷锟截帮拷锟斤拷志锟斤拷锟诫到锟斤拷锟斤拷锟叫★拷锟斤拷锟�锟斤拷 19.8.4 锟斤拷锟斤拷要锟斤拷锟斤拷 CSV 锟斤拷式锟斤拷锟斤拷志锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�logging_collector锟斤拷
注锟斤拷: 锟节达拷锟斤拷锟� Unix 系统锟较ｏ拷锟姐将锟斤拷要锟睫革拷系统锟斤拷syslog锟截伙拷锟斤拷锟教碉拷锟斤拷锟斤拷锟斤拷使锟斤拷log_destination锟斤拷syslog选锟筋。PostgreSQL锟斤拷锟斤拷锟斤拷syslog锟借备LOCAL0锟斤拷LOCAL7锟叫硷拷录锟斤拷锟斤拷syslog_facility锟斤拷锟斤拷锟斤拷锟角大部凤拷平台锟较碉拷默锟斤拷syslog锟斤拷锟矫会丢锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷息锟斤拷锟姐将锟斤拷要锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷ｏ拷
local0.* /var/log/postgresql锟斤拷syslog锟截伙拷锟斤拷锟教碉拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷 Windows 锟较ｏ拷锟斤拷锟斤拷使锟斤拷log_destination锟斤拷eventlog选锟斤拷时锟斤拷锟斤拷应锟斤拷锟节诧拷锟斤拷系统锟斤拷注锟斤拷一锟斤拷锟铰硷拷源锟斤拷锟斤拷猓拷锟斤拷锟� Windows 锟铰硷拷锟介看锟斤拷锟杰癸拷锟斤拷锟斤拷锟斤拷锟绞撅拷录锟斤拷锟街撅拷锟较拷锟斤拷锟斤拷锟斤拷 18.11 锟斤拷锟斤拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�锟斤拷志锟秸硷拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷捉锟斤拷锟斤拷锟酵碉拷stderr锟斤拷锟斤拷志锟斤拷息锟侥猴拷台锟斤拷锟教ｏ拷锟斤拷锟斤拷锟斤拷锟结将锟斤拷些锟斤拷息锟截讹拷锟斤拷锟斤拷志锟侥硷拷锟叫★拷锟斤拷锟街凤拷锟斤拷锟饺硷拷录锟斤拷syslog通锟斤拷锟斤拷锟斤拷锟矫ｏ拷锟斤拷为某些锟斤拷锟酵碉拷锟斤拷息锟斤拷锟斤拷锟斤拷syslog锟斤拷锟斤拷谐锟斤拷郑锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷嵌锟教拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟较拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟�archive_command锟饺脚憋拷锟斤拷锟斤拷锟侥达拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷诜锟斤拷锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷谩锟�
注锟斤拷: 也锟斤拷锟皆诧拷使锟斤拷锟斤拷志锟秸硷拷锟斤拷锟斤拷锟斤拷锟斤拷志锟斤拷录锟斤拷stderr锟斤拷锟斤拷志锟斤拷息锟斤拷只锟斤拷去锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷stderr锟斤拷锟斤拷锟津到碉拷位锟矫★拷锟斤拷锟斤拷锟斤拷锟斤拷锟街凤拷锟斤拷只锟绞猴拷锟节碉拷锟斤拷志锟斤拷锟斤拷锟斤拷为锟斤拷没锟斤拷锟结供锟斤拷锟斤拷锟斤拷锟斤拷转锟斤拷志锟侥硷拷锟斤拷锟斤拷锟叫ｏ拷锟斤拷某些锟斤拷使锟斤拷锟斤拷志锟秸硷拷锟斤拷锟斤拷平台锟较匡拷锟杰会导锟铰讹拷失锟斤拷锟竭伙拷锟斤拷锟斤拷志锟斤拷锟斤拷锟斤拷锟轿拷锟斤拷锟斤拷锟教诧拷锟斤拷写锟斤拷同一锟斤拷锟斤拷志锟侥硷拷时锟结覆锟角彼此碉拷锟斤拷锟斤拷锟�
注锟斤拷: 锟斤拷志锟秸硷拷锟斤拷锟斤拷锟斤拷瞥纱锟斤拷锟斤拷锟斤拷岫э拷锟较拷锟斤拷锟斤拷锟轿讹拷锟斤拷诩锟斤拷叩母锟斤拷锟斤拷拢锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷图锟斤拷锟秸硷拷锟斤拷锟窖撅拷锟斤拷锟绞憋拷锟斤拷透锟斤拷锟斤拷锟斤拷志锟斤拷息锟斤拷锟斤拷么锟斤拷锟结被锟斤拷锟斤拷锟斤拷锟洁反锟斤拷syslog锟斤拷锟斤拷锟斤拷锟斤拷锟睫凤拷写锟斤拷锟斤拷息时锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷味锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷芑锟斤拷薹锟斤拷锟铰寄承╋拷锟较拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟较低筹拷锟斤拷锟斤拷锟斤拷锟斤拷帧锟�
锟斤拷logging_collector锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷锟斤拷母锟侥柯硷拷麓锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷员锟街革拷锟轿伙拷锟斤拷锟斤拷锟铰凤拷锟斤拷锟揭诧拷锟斤拷员锟街革拷锟轿伙拷锟斤拷锟斤拷锟节硷拷锟斤拷锟斤拷锟斤拷目录锟斤拷锟斤拷锟铰凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷 默锟斤拷锟斤拷pg_log锟斤拷
锟斤拷logging_collector锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷帽锟斤拷锟斤拷锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷募锟斤拷锟斤拷锟斤拷锟街碉拷锟斤拷锟轿伙拷锟�strftime模式锟斤拷锟斤拷锟�%转锟斤拷锟斤拷员锟斤拷锟斤拷锟街革拷锟斤拷锟斤拷锟绞憋拷锟戒化锟斤拷锟侥硷拷锟斤拷锟斤拷注锟斤拷锟斤拷锟斤拷锟斤拷魏锟绞憋拷锟斤拷锟斤拷锟斤拷锟�%转锟藉，锟斤拷锟姐将锟斤拷锟斤拷log_timezone指锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷桑锟斤拷锟斤拷锟街э拷值锟�%转锟斤拷涂锟斤拷锟斤拷锟街拷锟�strftime说锟斤拷锟斤拷锟叫举碉拷锟斤拷锟狡★拷
注锟斤拷系统锟斤拷strftime锟斤拷锟结被直锟斤拷使锟矫ｏ拷锟斤拷锟狡教拷锟截ｏ拷锟角憋拷准锟斤拷锟斤拷锟斤拷展锟睫凤拷锟斤拷锟斤拷锟斤拷
默锟斤拷锟斤拷postgresql-%Y-%m-%d_%H%M%S.log锟斤拷
锟斤拷锟斤拷悴皇癸拷锟阶拷锟斤拷锟街革拷锟揭伙拷锟斤拷募锟斤拷锟斤拷锟斤拷锟接︼拷眉苹锟绞癸拷锟揭伙拷锟斤拷锟街撅拷锟阶拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷獭锟斤拷锟� 8.4 锟斤拷锟斤拷之前锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�%转锟藉，PostgreSQL锟斤拷追锟斤拷锟斤拷锟斤拷志锟侥硷拷锟斤拷锟斤拷时锟斤拷募锟皆拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷丫锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷恕锟�
锟斤拷锟斤拷锟�log_destination锟斤拷锟斤拷锟斤拷锟斤拷 CSV 锟斤拷式锟斤拷锟斤拷锟�.csv锟斤拷锟结被追锟接碉拷时锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� CSV 锟斤拷式锟斤拷锟斤拷锟斤拷锟斤拷log_filename锟斤拷.log锟斤拷尾锟斤拷锟矫猴拷缀锟结被锟芥换锟斤拷锟斤拷
锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷 Unix 系统锟较ｏ拷锟斤拷logging_collector锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街撅拷募锟斤拷锟饺拷蓿锟斤拷锟轿拷锟� Windows 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷裕锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷值应锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷式锟斤拷模式锟斤拷锟斤拷锟斤拷锟皆憋拷chmod锟斤拷umask系统锟斤拷锟矫斤拷锟杰ｏ拷要使锟斤拷通锟斤拷锟斤拷十锟斤拷锟狡革拷式锟斤拷锟斤拷锟斤拷锟街憋拷锟斤拷锟斤拷一锟斤拷0锟斤拷锟姐）锟斤拷始锟斤拷锟斤拷
默锟较碉拷权锟斤拷锟斤拷0600锟斤拷锟斤拷示只锟叫凤拷锟斤拷锟斤拷拥锟斤拷锟竭诧拷锟杰讹拷取锟斤拷写锟斤拷锟斤拷志锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫碉拷锟斤拷锟斤拷锟斤拷0640锟斤拷锟斤拷锟斤拷锟斤拷拥锟斤拷锟竭碉拷锟斤拷锟皆憋拷锟饺★拷募锟斤拷锟斤拷锟斤拷锟揭拷锟斤拷锟斤拷锟揭拷薷锟�log_directory为锟斤拷锟侥硷拷锟芥储锟节硷拷锟斤拷锟斤拷锟斤拷目录之锟斤拷锟侥筹拷锟轿伙拷茫锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷锟斤拷锟轿猴拷锟斤拷锟斤拷拢锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷锟轿猴拷锟剿讹拷锟缴讹拷锟角诧拷锟斤拷锟角的ｏ拷锟斤拷为锟斤拷志锟侥硷拷锟叫匡拷锟杰帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷★拷
锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷logging_collector锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷畛わ拷锟斤拷锟斤拷凇锟斤拷锟斤拷锟叫╋拷锟斤拷庸锟饺ワ拷锟揭伙拷锟斤拷碌锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟姐将锟斤拷锟矫伙拷锟斤拷时锟斤拷锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷logging_collector锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷叽纭ｏ拷锟斤拷锟矫达拷锟角э拷纸诒锟斤拷锟斤拷偷锟揭伙拷锟斤拷锟街撅拷募锟斤拷螅锟斤拷锟斤拷锟揭伙拷锟斤拷碌锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟姐将锟斤拷锟矫伙拷锟节尺达拷锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷logging_collector锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�PostgreSQL锟截断ｏ拷锟斤拷锟角讹拷锟斤拷锟斤拷追锟接ｏ拷锟轿猴拷锟斤拷锟叫碉拷同锟斤拷锟斤拷志锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟截讹拷只锟斤拷一锟斤拷锟斤拷锟侥硷拷锟斤拷锟节伙拷锟斤拷时锟斤拷锟斤拷锟阶拷锟斤拷锟绞憋拷锟斤拷锟斤拷锟斤拷诜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟节尺达拷锟斤拷锟阶憋拷锟斤拷岱拷锟斤拷锟斤拷锟斤拷锟斤拷锟截闭ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟角帮拷锟斤拷诘锟斤拷募锟斤拷锟斤拷锟阶凤拷印锟斤拷锟斤拷纾癸拷锟斤拷锟斤拷锟斤拷锟矫猴拷一锟斤拷锟斤拷锟斤拷postgresql-%H.log锟斤拷log_filename锟斤拷锟斤拷锟铰诧拷锟斤拷 24 锟斤拷每小时锟斤拷锟斤拷志锟侥硷拷锟斤拷锟斤拷锟斤拷循锟斤拷锟截革拷锟斤拷锟斤拷锟角★拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟接ｏ拷要锟斤拷锟斤拷 7 锟斤拷锟斤拷锟街撅拷锟矫匡拷锟斤拷一锟斤拷锟斤拷志锟侥硷拷锟斤拷锟斤拷锟斤拷为server_log.Mon锟斤拷server_log.Tue锟饺等ｏ拷锟斤拷锟斤拷锟皆讹拷锟矫憋拷锟杰碉拷锟斤拷志锟斤拷锟斤拷锟斤拷一锟杰碉拷锟斤拷志锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷log_filename锟斤拷锟斤拷为server_log.%a锟斤拷锟斤拷log_truncate_on_rotation锟斤拷锟斤拷为on锟斤拷锟揭斤拷log_rotation_age锟斤拷锟斤拷为1440锟斤拷
锟斤拷锟接ｏ拷要锟斤拷锟斤拷 24 小时锟斤拷锟斤拷志锟斤拷每锟斤拷小时一锟斤拷锟斤拷志锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷志锟侥硷拷锟竭寸超锟斤拷 1GB 时锟斤拷转锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷log_filename锟斤拷锟斤拷为server_log.%H%M锟斤拷 锟斤拷log_truncate_on_rotation锟斤拷锟斤拷为on锟斤拷 锟斤拷log_rotation_age锟斤拷锟斤拷为60锟斤拷锟斤拷 锟斤拷log_rotation_size锟斤拷锟斤拷为1000000锟斤拷 Including %M in 锟斤拷log_filename锟叫帮拷锟斤拷%M锟斤拷锟斤拷锟斤拷锟斤拷锟轿何尺达拷锟斤拷锟斤拷锟斤拷锟斤拷转锟斤拷选锟斤拷一锟斤拷锟斤拷同锟斤拷每锟斤拷小时锟侥筹拷始锟侥硷拷锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷syslog锟斤拷录时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭癸拷玫锟�syslog"锟借备"锟斤拷锟斤拷锟斤拷锟斤拷锟�LOCAL0锟斤拷LOCAL1锟斤拷LOCAL2锟斤拷LOCAL3锟斤拷LOCAL4锟斤拷 LOCAL5锟斤拷LOCAL6锟斤拷LOCAL7锟斤拷选锟斤拷默锟斤拷值锟斤拷LOCAL0锟斤拷锟斤拷锟斤拷锟斤拷锟较低筹拷锟�syslog锟截伙拷锟斤拷锟教碉拷锟侥碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷syslog锟斤拷录时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞�syslog锟叫碉拷PostgreSQL锟斤拷息锟侥筹拷锟斤拷锟斤拷锟斤拷默锟斤拷值锟斤拷postgres锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟斤拷志锟斤拷锟斤拷录锟斤拷syslog锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿� on 锟斤拷默锟较ｏ拷时锟斤拷每一锟斤拷锟斤拷息锟结被锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿白猴拷锟斤拷锟斤拷锟� [2]锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟杰匡拷锟剿很讹拷 syslog 实锟斤拷默锟较诧拷锟矫碉拷 "--- 锟斤拷一锟斤拷锟斤拷息锟截革拷 N 锟斤拷 ---"锟斤拷式锟斤拷锟斤拷锟街达拷 syslog 实锟斤拷锟叫ｏ拷 锟斤拷锟斤拷锟截革拷锟斤拷息锟角匡拷锟斤拷锟斤拷锟矫的ｏ拷锟斤拷锟斤拷rsyslog 锟叫碉拷$RepeatedMsgReduction锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟杰诧拷锟角憋拷锟斤拷摹锟� 锟斤拷锟解，锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟截革拷锟斤拷息锟斤拷锟斤拷锟斤拷园锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为 off锟斤拷
锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟斤拷锟竭凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟斤拷锟矫帮拷锟斤拷志锟斤拷录锟斤拷syslog时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟较拷锟斤拷锟酵达拷 syslog锟斤拷锟斤拷锟斤拷锟斤拷为 on锟斤拷默锟较ｏ拷时锟斤拷锟斤拷息锟结被锟街筹拷锟叫ｏ拷 锟斤拷锟揭筹拷锟斤拷锟斤拷也锟结被锟斤拷锟斤拷锟皆憋拷锟杰癸拷锟脚碉拷 1024 锟街斤拷锟叫ｏ拷 锟斤拷锟角达拷统 syslog 实锟斤拷一锟街碉拷锟酵的尺达拷锟斤拷锟狡★拷锟斤拷锟斤拷锟斤拷为 off 时锟斤拷 PostgreSQL 锟斤拷锟斤拷锟斤拷锟斤拷志锟斤拷息锟结被原锟斤拷锟酵达拷 syslog 锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟杰的达拷锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷 syslog 锟斤拷锟斤拷锟斤拷
锟斤拷锟� syslog 锟斤拷锟秸憋拷锟斤拷录锟斤拷一锟斤拷锟侥憋拷锟侥硷拷锟叫ｏ拷锟斤拷么锟斤拷锟斤拷锟斤拷锟矫碉拷效锟斤拷锟斤拷一锟斤拷锟侥ｏ拷 锟斤拷锟斤拷锟斤拷锟斤拷锟轿� on锟斤拷锟斤拷为锟襟部凤拷 syslog 实锟斤拷要么锟斤拷锟杰达拷锟斤拷锟斤拷锟斤拷锟斤拷息锟斤拷 要么锟斤拷要锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷源锟斤拷锟斤拷锟斤拷锟斤拷锟较拷锟斤拷锟斤拷锟斤拷锟斤拷 syslog 锟斤拷锟斤拷写锟诫到某锟斤拷锟斤拷锟斤拷媒锟介，锟叫憋拷要锟斤拷锟斤拷息锟斤拷锟斤拷锟竭硷拷锟较碉拷锟斤拷锟斤拷锟皆ｏ拷也锟斤拷锟斤拷锟斤拷锟矫ｏ拷锟斤拷
锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟斤拷锟竭凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟铰硷拷锟斤拷志锟斤拷录时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞讹拷锟街撅拷锟�PostgreSQL锟斤拷息锟侥筹拷锟斤拷锟斤拷锟斤拷默锟斤拷值锟斤拷PostgreSQL锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟狡憋拷锟斤拷锟酵革拷锟酵伙拷锟剿碉拷锟斤拷息锟斤拷锟斤拷锟斤拷效值锟斤拷DEBUG5锟斤拷 DEBUG4锟斤拷DEBUG3锟斤拷DEBUG2锟斤拷 DEBUG1锟斤拷LOG锟斤拷NOTICE锟斤拷 WARNING锟斤拷ERROR锟斤拷FATAL锟斤拷PANIC锟斤拷每锟斤拷锟斤拷锟金都帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫硷拷锟金。硷拷锟斤拷越锟斤拷锟襟，憋拷锟斤拷锟酵碉拷锟斤拷息越锟劫★拷默锟斤拷值锟斤拷NOTICE锟斤拷注锟斤拷LOG锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷log_min_messages锟叫诧拷同锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟斤拷锟斤拷些锟斤拷息锟斤拷锟斤拷写锟诫到锟斤拷锟斤拷锟斤拷锟斤拷志锟斤拷锟斤拷效值锟斤拷DEBUG5锟斤拷DEBUG4锟斤拷 DEBUG3锟斤拷DEBUG2锟斤拷DEBUG1锟斤拷 INFO锟斤拷NOTICE锟斤拷WARNING锟斤拷 ERROR锟斤拷LOG锟斤拷FATAL锟斤拷 PANIC锟斤拷每锟斤拷锟斤拷锟金都帮拷锟斤拷锟皆猴拷锟斤拷锟斤拷屑锟斤拷稹＜锟斤拷锟皆斤拷锟斤拷螅锟斤拷锟斤拷偷锟斤拷锟较⒃斤拷佟锟侥拷锟街碉拷锟�WARNING锟斤拷注锟斤拷LOG锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷log_min_messages锟叫诧拷同锟斤拷锟斤拷锟斤拷锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟斤拷锟皆改憋拷锟斤拷锟斤拷锟斤拷谩锟�
锟斤拷锟斤拷锟斤拷些锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� SQL 锟斤拷浔伙拷锟铰硷拷诜锟斤拷锟斤拷锟斤拷锟街撅拷小锟斤拷魏锟街革拷锟斤拷锟斤拷丶锟斤拷锟斤拷锟斤拷呒锟斤拷锟斤拷锟斤拷息锟侥碉拷前 SQL 锟斤拷浣拷锟斤拷锟斤拷锟斤拷锟斤拷锟街撅拷锟斤拷小锟斤拷锟叫е碉拷锟�DEBUG5锟斤拷 DEBUG4锟斤拷DEBUG3锟斤拷 DEBUG2锟斤拷DEBUG1锟斤拷 INFO锟斤拷NOTICE锟斤拷 WARNING锟斤拷ERROR锟斤拷 LOG锟斤拷 FATAL锟斤拷PANIC锟斤拷默锟斤拷值锟斤拷ERROR锟斤拷锟斤拷锟斤拷示锟斤拷锟铰达拷锟斤拷锟斤拷志锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街慌达拷锟斤拷锟斤拷锟戒将锟斤拷锟斤拷录锟斤拷锟斤拷志锟叫★拷要锟斤拷效锟截关闭硷拷录失锟斤拷锟斤拷洌拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为PANIC锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟斤拷锟皆改憋拷锟斤拷锟斤拷锟斤拷谩锟�
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷指锟斤拷锟侥猴拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟铰硷拷录每一锟斤拷锟斤拷锟斤拷锟斤拷傻锟斤拷锟斤拷某锟斤拷锟绞憋拷洹ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟姐将锟斤拷印锟斤拷锟斤拷锟斤拷锟斤拷执锟斤拷时锟戒。锟斤拷锟斤拷为 -1 锟斤拷默锟斤拷值锟斤拷锟斤拷停止锟斤拷录锟斤拷锟斤拷锟斤拷时锟戒。锟斤拷锟界，锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿�250ms锟斤拷锟斤拷么锟斤拷锟斤拷锟斤拷锟斤拷 250ms 锟斤拷锟斤拷玫锟� SQL 锟斤拷浣拷锟斤拷锟铰硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷追锟斤拷应锟斤拷锟斤拷未锟脚伙拷锟侥诧拷询锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟斤拷锟皆改憋拷锟斤拷锟斤拷锟斤拷谩锟�
锟斤拷锟斤拷使锟斤拷锟斤拷展锟斤拷询协锟斤拷目突锟斤拷耍锟斤拷锟斤拷锟斤拷锟斤拷蠖ê锟街达拷胁锟斤拷锟侥筹拷锟斤拷时锟戒将锟斤拷锟斤拷锟斤拷锟斤拷录锟斤拷
注锟斤拷: 锟斤拷锟斤拷锟斤拷锟窖★拷锟斤拷log_statement一锟斤拷使锟斤拷时锟斤拷锟窖撅拷锟斤拷log_statement锟斤拷录锟斤拷锟斤拷锟斤拷谋锟斤拷锟斤拷锟斤拷诔锟斤拷锟绞憋拷锟斤拷锟街撅拷锟较拷锟斤拷馗锟斤拷锟斤拷锟斤拷锟斤拷没锟斤拷使锟斤拷syslog锟斤拷锟斤拷锟斤拷锟狡硷拷锟斤拷使锟斤拷log_line_prefix锟斤拷录 PID 锟斤拷峄� ID锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞癸拷媒锟斤拷锟� ID 锟斤拷峄� ID 锟斤拷锟斤拷锟斤拷锟较拷锟斤拷拥锟斤拷锟斤拷锟斤拷某锟斤拷锟绞憋拷锟斤拷锟较拷锟�
锟斤拷 19-1锟斤拷锟斤拷锟斤拷PostgreSQL锟斤拷使锟矫碉拷锟斤拷息锟斤拷锟截硷拷锟斤拷锟斤拷锟斤拷锟街撅拷锟斤拷锟斤拷锟斤拷锟酵碉拷syslog锟斤拷 Windows 锟斤拷eventlog锟斤拷锟斤拷锟截硷拷锟斤拷岚达拷毡锟斤拷锟斤拷锟绞撅拷锟斤拷锟阶拷锟斤拷锟�
锟斤拷 19-1. 锟斤拷息锟斤拷锟截硷拷锟斤拷
| 锟斤拷锟斤拷锟斤拷 | 锟矫凤拷 | syslog | eventlog |
|---|---|---|---|
| DEBUG1..DEBUG5 | 为锟斤拷锟斤拷锟斤拷锟结供锟斤拷锟斤拷锟侥革拷锟斤拷细锟斤拷锟斤拷息锟斤拷 | DEBUG | INFORMATION |
| INFO | 锟结供锟矫伙拷锟斤拷式要锟斤拷锟斤拷锟较拷锟斤拷锟斤拷锟斤拷锟斤拷锟�VACUUM VERBOSE锟斤拷锟斤拷锟斤拷锟� | INFO | INFORMATION |
| NOTICE | 锟结供锟斤拷锟杰讹拷锟矫伙拷锟斤拷锟矫碉拷锟斤拷息锟斤拷锟斤拷锟界长锟斤拷识锟斤拷锟截讹拷锟斤拷示锟斤拷 | NOTICE | INFORMATION |
| WARNING | 锟结供锟斤拷锟杰筹拷锟街碉拷锟斤拷锟斤拷木锟斤拷妫拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷COMMIT锟斤拷 | NOTICE | WARNING |
| ERROR | 锟斤拷锟斤拷一锟斤拷锟斤拷锟铰碉拷前锟斤拷锟斤拷锟叫断的达拷锟斤拷 | WARNING | ERROR |
| LOG | 锟斤拷锟斤拷锟斤拷锟皆憋拷锟斤拷芨锟斤拷锟饺わ拷锟斤拷锟较拷锟斤拷锟斤拷锟斤拷锟斤拷疃拷锟� | INFO | INFORMATION |
| FATAL | 锟斤拷锟斤拷一锟斤拷锟斤拷锟铰碉拷前锟结话锟叫断的达拷锟斤拷 | ERR | ERROR |
| PANIC | 锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷匡拷峄帮拷卸系拇锟斤拷锟� | CRIT | ERROR |
application_name锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫★拷锟絅AMEDATALEN锟斤拷锟街凤拷 锟斤拷锟斤拷准锟斤拷锟斤拷锟斤拷64锟街凤拷锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷一锟斤拷锟斤拷锟接凤拷锟斤拷锟斤拷锟斤拷牡锟接︼拷贸锟斤拷锟斤拷锟斤拷谩锟� 锟斤拷锟街伙拷锟铰硷拷锟絧g_stat_activity锟斤拷CSV锟斤拷志锟斤拷目锟叫★拷 也锟斤拷锟斤拷通锟斤拷log_line_prefix锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟节癸拷锟缴碉拷锟斤拷志锟斤拷目锟叫★拷 只锟叫可达拷印锟斤拷ASCII锟街凤拷锟斤拷锟皆憋拷锟斤拷锟斤拷application_name锟斤拷 锟斤拷锟斤拷锟街凤拷锟结被锟绞猴拷(?)锟芥换锟斤拷 application_name锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷小锟斤拷NAMEDATALEN锟斤拷锟街凤拷锟斤拷锟斤拷准锟斤拷锟斤拷锟斤拷锟斤拷 64 锟斤拷锟街凤拷锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷一锟斤拷应锟斤拷通锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷锟斤拷锟斤拷锟狡斤拷锟斤拷锟斤拷示锟斤拷pg_stat_activity锟斤拷图锟叫诧拷锟斤拷锟斤拷锟斤拷锟斤拷 CSV 锟斤拷志锟斤拷锟叫★拷锟斤拷也锟结被通锟斤拷log_line_prefix锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷志锟斤拷锟叫★拷只锟叫可达拷印 ASCII 锟街凤拷锟杰憋拷使锟斤拷锟斤拷application_name之锟叫★拷锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟芥换为锟绞号ｏ拷?锟斤拷锟斤拷
锟斤拷些锟斤拷锟斤拷锟斤拷锟斤拷锟矫讹拷锟街碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷锟斤拷锟轿恳伙拷锟斤拷锟街达拷械牟锟窖拷锟接★拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷询锟斤拷写锟斤拷锟斤拷锟斤拷锟街达拷屑苹锟斤拷锟斤拷锟叫╋拷锟较拷锟�LOG锟斤拷息锟斤拷锟斤拷锟较憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥拷锟斤拷锟斤拷锟斤拷锟斤拷锟角斤拷锟斤拷锟斤拷锟节凤拷锟斤拷锟斤拷锟斤拷志锟叫碉拷锟斤拷锟结被锟斤拷锟酵碉拷锟酵伙拷锟剿★拷锟斤拷锟斤拷锟酵拷锟斤拷锟斤拷锟�client_min_messages锟斤拷/锟斤拷log_min_messages锟斤拷锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟侥拷锟斤拷枪乇盏摹锟�
锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷debug_pretty_print锟斤拷锟斤拷锟斤拷锟斤拷debug_print_parse锟斤拷 debug_print_rewritten锟斤拷 debug_print_plan锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷饨拷锟斤拷卤裙乇詹锟斤拷锟绞笔癸拷玫锟�"锟斤拷锟斤拷"模式锟缴讹拷锟皆革拷强锟斤拷锟角革拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥拷锟斤拷谴蚩摹锟�
锟斤拷锟铰硷拷锟斤拷锟斤拷锟斤拷锟斤拷惚伙拷锟铰硷拷诜锟斤拷锟斤拷锟斤拷锟街撅拷小锟揭恍┩筹拷锟斤拷锟较⒁诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟街撅拷锟较拷校锟斤拷锟斤拷锟叫达拷牖猴拷锟斤拷锟斤拷锟斤拷锟斤拷莺锟叫达拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞憋拷洹ｏ拷锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷默锟斤拷值锟角关闭★拷
锟斤拷锟斤拷每一锟轿筹拷锟皆对凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟接憋拷锟斤拷录锟斤拷锟酵伙拷锟斤拷锟斤拷证锟侥成癸拷锟斤拷锟揭诧拷岜伙拷锟铰硷拷锟� 只锟叫筹拷锟斤拷锟矫伙拷锟节会话锟斤拷锟斤拷时锟斤拷锟皆改憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷谢峄帮拷胁锟斤拷芨谋洹� 缺省锟斤拷off锟斤拷
注锟斤拷: 某些锟酵伙拷锟剿筹拷锟斤拷锟斤拷锟斤拷psql锟斤拷锟斤拷要锟斤拷锟斤拷锟斤拷时锟结尝锟斤拷锟斤拷锟斤拷锟斤拷锟轿ｏ拷锟斤拷锟斤拷馗锟斤拷锟�"锟秸碉拷锟斤拷锟斤拷"锟斤拷息锟斤拷锟斤拷一锟斤拷锟斤拷示一锟斤拷锟斤拷锟斤拷
锟斤拷录锟结话锟斤拷止原锟斤拷锟斤拷志锟斤拷锟斤拷峁╋拷锟较拷锟斤拷锟斤拷锟�log_connections锟斤拷 锟皆硷拷锟结话锟斤拷锟斤拷时锟戒。只锟叫筹拷锟斤拷锟矫伙拷锟节会话锟斤拷锟斤拷时锟斤拷锟皆改憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟� 锟斤拷锟斤拷锟斤拷锟斤拷锟叫会话锟叫诧拷锟杰改变。缺省锟斤拷off锟斤拷
锟斤拷锟斤拷每一锟斤拷锟斤拷傻锟斤拷锟斤拷某锟斤拷锟绞憋拷浔伙拷锟铰硷拷锟侥拷锟街碉拷锟�off锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟斤拷锟皆改憋拷锟斤拷锟斤拷锟斤拷谩锟�
锟斤拷锟斤拷使锟斤拷锟斤拷展锟斤拷询协锟斤拷目突锟斤拷耍锟斤拷锟斤拷锟斤拷锟斤拷蠖ê锟街达拷胁锟斤拷锟侥筹拷锟斤拷时锟戒将锟斤拷锟斤拷锟斤拷锟斤拷录锟斤拷
注锟斤拷: 锟斤拷锟斤拷锟斤拷锟窖★拷锟斤拷锟斤拷锟斤拷log_min_duration_statement为锟斤拷之锟斤拷锟斤拷锟斤拷锟斤拷牵锟斤拷锟斤拷锟�log_min_duration_statement强锟狡诧拷询锟斤拷锟侥憋拷锟斤拷锟斤拷录锟斤拷锟斤拷锟斤拷锟窖★拷畈伙拷帷ｏ拷锟剿ｏ拷锟斤拷锟�log_duration为on锟斤拷锟斤拷log_min_duration_statement为锟斤拷值锟斤拷锟斤拷锟叫筹拷锟斤拷时锟戒都锟斤拷锟斤拷锟斤拷录锟斤拷锟斤拷锟斤拷只锟叫筹拷锟斤拷锟斤拷值锟斤拷锟斤拷锟脚会被锟斤拷录锟斤拷询锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷为锟斤拷锟斤拷锟斤拷锟节高革拷锟截帮拷装锟斤拷锟秸硷拷统锟斤拷锟斤拷息锟斤拷
锟斤拷锟斤拷为每一锟斤拷锟斤拷锟斤拷录锟斤拷锟斤拷息要写锟诫到锟斤拷锟斤拷锟斤拷锟斤拷志锟斤拷细锟斤拷锟斤拷锟斤拷锟斤拷效值锟斤拷TERSE锟斤拷DEFAULT锟斤拷VERBOSE锟斤拷每一锟斤拷锟斤拷为锟斤拷示锟斤拷锟斤拷息锟斤拷锟接革拷锟斤拷锟斤拷TERSE锟脚筹拷锟斤拷录DETAIL锟斤拷HINT锟斤拷QUERY锟斤拷CONTEXT锟斤拷锟斤拷锟斤拷息锟斤拷VERBOSE锟斤拷锟斤拷锟斤拷锟�SQLSTATE锟斤拷锟斤拷锟诫（锟斤拷锟斤拷录 A锟斤拷锟皆硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟皆达拷锟斤拷锟斤拷募锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷泻拧锟街伙拷谐锟斤拷锟斤拷没锟斤拷芄锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
默锟斤拷锟斤拷锟斤拷拢锟斤拷锟斤拷锟斤拷锟街撅拷锟较⒅伙拷锟绞撅拷锟斤拷锟斤拷锟斤拷锟斤拷锟� IP 锟斤拷址锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭诧拷锟铰硷拷锟斤拷锟斤拷锟斤拷锟阶拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷茫锟斤拷锟斤拷锟杰会导锟铰猴拷微小锟斤拷锟斤拷锟斤拷锟斤拷失锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟斤拷一锟斤拷printf锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷每锟斤拷锟斤拷志锟叫的匡拷头锟斤拷锟斤拷锟�%锟街凤拷锟斤拷始"转锟斤拷锟斤拷锟斤拷"锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟芥换锟斤拷状态锟斤拷息锟斤拷未识锟斤拷锟阶拷灞伙拷锟斤拷浴锟斤拷锟斤拷锟斤拷址锟斤拷锟街憋拷痈锟斤拷频锟斤拷锟街撅拷小锟侥承┳拷锟街伙拷锟斤拷峄帮拷锟斤拷锟绞讹拷锟斤拷冶锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷痰群锟教拷锟斤拷痰锟斤拷锟斤拷铡锟酵拷锟街革拷锟揭伙拷锟斤拷锟�%之锟斤拷透锟窖★拷锟街帮拷锟斤拷锟斤拷挚锟斤拷锟斤拷锟阶刺拷锟较拷锟斤拷锟斤拷锟斤拷叶锟斤拷搿�
锟斤拷值锟斤拷锟斤拷锟斤拷锟斤拷锟揭憋拷锟矫空革拷锟斤拷锟阶刺拷锟较拷汛锏斤拷锟叫★拷锟斤拷龋锟斤拷锟斤拷锟街碉拷锟斤拷锟斤拷锟斤拷锟斤拷洹ｏ拷锟斤拷锟斤拷锟斤拷锟街撅拷锟�
锟斤拷锟斤拷锟斤拷锟斤拷啥锟斤拷源锟斤拷邪锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷默锟斤拷值锟斤拷一锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷
| 转锟斤拷 | 效锟斤拷 | 只锟睫会话 |
|---|---|---|
| %a | 应锟斤拷锟斤拷 | 锟斤拷 |
| %u | 锟矫伙拷锟斤拷 | 锟斤拷 |
| %d | 锟斤拷锟捷匡拷锟斤拷 | 锟斤拷 |
| %r | 远锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 IP 锟斤拷址锟斤拷锟皆硷拷远锟教端匡拷 | 锟斤拷 |
| %h | 远锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 IP 锟斤拷址 | 锟斤拷 |
| %p | 锟斤拷锟斤拷 ID | 锟斤拷 |
| %t | 锟睫猴拷锟斤拷锟绞憋拷锟斤拷 | 锟斤拷 |
| %m | 锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷 | 锟斤拷 |
| %n | 锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷锟斤拷锟斤拷为 Unix 时锟斤拷锟斤拷锟� | 锟斤拷 |
| %i | 锟斤拷锟斤拷锟角╋拷锟斤拷峄帮拷锟角帮拷锟斤拷锟斤拷锟斤拷锟斤拷 | 锟斤拷 |
| %e | SQLSTATE 锟斤拷锟斤拷锟斤拷锟� | 锟斤拷 |
| %c | 锟结话 ID锟斤拷锟斤拷锟斤拷锟斤拷 | 锟斤拷 |
| %l | 锟斤拷每锟斤拷锟结话锟斤拷锟斤拷痰锟斤拷锟街撅拷泻牛锟斤拷锟� 1 锟斤拷始 | 锟斤拷 |
| %s | 锟斤拷锟教匡拷始锟斤拷时锟斤拷锟� | 锟斤拷 |
| %v | 锟斤拷锟斤拷锟斤拷锟斤拷 ID (backendID/localXID) | 锟斤拷 |
| %x | 锟斤拷锟斤拷 ID 锟斤拷锟斤拷锟轿达拷锟斤拷锟斤拷锟轿� 0锟斤拷 | 锟斤拷 |
| %q | 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷歉锟斤拷叻腔峄帮拷锟斤拷锟斤拷锟斤拷址锟斤拷锟斤拷锟斤拷锟揭伙拷锟酵Ｖ癸拷锟斤拷峄帮拷锟斤拷毯锟斤拷锟� | 锟斤拷 |
| %% | 锟斤拷锟斤拷锟斤拷 % | 锟斤拷 |
SELECT to_hex(trunc(EXTRACT(EPOCH FROM backend_start))::integer) || '.' ||
to_hex(pid)
FROM pg_stat_activity;
锟斤拷示: 锟斤拷锟斤拷锟轿�log_line_prefix锟斤拷锟斤拷锟剿非匡拷值锟斤拷锟斤拷通锟斤拷应锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷址锟轿拷崭锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷峁╋拷锟斤拷锟街撅拷械锟绞ｏ拷嗖匡拷值锟斤拷泳锟斤拷锟斤拷锟揭诧拷锟斤拷锟绞癸拷帽锟斤拷锟斤拷拧锟�
锟斤拷示: Syslog锟斤拷锟斤拷锟皆硷拷锟斤拷时锟斤拷锟斤拷徒锟斤拷锟� ID 锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟铰硷拷锟�syslog锟斤拷锟斤拷懿锟较ｏ拷锟斤拷锟斤拷锟斤拷锟叫┳拷濉�
锟斤拷锟狡碉拷一锟斤拷锟结话为锟斤拷锟揭伙拷锟斤拷锟斤拷鹊锟斤拷锟斤拷锟�deadlock_timeout时锟斤拷锟角凤拷要锟斤拷锟斤拷一锟斤拷锟斤拷志锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷锟节撅拷锟斤拷锟角凤拷锟斤拷锟饺达拷锟斤拷锟斤拷锟斤拷锟斤拷艿锟斤拷隆锟侥拷锟街碉拷锟�off锟斤拷
锟斤拷锟斤拷锟斤拷些 SQL 锟斤拷浔伙拷锟铰硷拷锟斤拷锟叫е碉拷锟� none (off)锟斤拷ddl锟斤拷mod锟斤拷 all锟斤拷锟斤拷锟斤拷锟斤拷洌╋拷锟�ddl锟斤拷录锟斤拷锟斤拷锟斤拷锟捷讹拷锟斤拷锟斤拷洌拷锟斤拷锟�CREATE锟斤拷ALTER锟斤拷 DROP锟斤拷洹�mod锟斤拷录锟斤拷锟斤拷ddl锟斤拷洌拷锟斤拷锟斤拷锟斤拷锟睫革拷锟斤拷锟斤拷锟斤拷锟�INSERT, UPDATE锟斤拷DELETE锟斤拷TRUNCATE, 锟斤拷COPY FROM锟斤拷 锟斤拷锟�PREPARE锟斤拷EXECUTE锟斤拷 EXPLAIN ANALYZE锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵碉拷锟斤拷锟筋，锟斤拷锟斤拷也锟结被锟斤拷录锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷展锟斤拷询协锟斤拷目突锟斤拷耍锟斤拷锟斤拷盏锟揭伙拷锟街达拷锟斤拷锟较⑹憋拷锟斤拷锟斤拷锟斤拷志锟斤拷锟揭伙拷锟斤拷锟斤拷蠖ú锟斤拷锟斤拷锟街碉拷锟斤拷魏锟斤拷锟角讹拷牡锟斤拷锟斤拷呕岜凰达拷锟斤拷锟�
默锟斤拷值锟斤拷none锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟斤拷锟皆改憋拷锟斤拷锟斤拷锟斤拷谩锟�
注锟斤拷: 锟斤拷使锟斤拷锟斤拷锟斤拷log_statement=all锟斤拷锟斤拷锟斤拷 锟斤拷锟斤法锟斤拷锟斤拷锟斤拷锟斤拷也锟斤拷锟结被锟斤拷录锟斤拷锟斤拷为锟斤拷锟斤拷锟斤拷苫锟斤拷锟斤拷锟斤拷锓拷锟斤拷锟斤拷锟� 确锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街拷锟脚硷拷录锟斤拷志锟斤拷锟斤拷使锟斤拷锟斤拷展锟斤拷询协锟斤拷锟斤拷锟斤拷锟铰ｏ拷锟斤拷 执锟叫阶讹拷之前(锟斤法锟斤拷锟斤拷锟斤拷婊拷锥锟�)同锟斤拷锟斤拷锟斤拷锟铰硷拷锟斤拷锟� log_min_error_statement锟斤拷为ERROR 锟斤拷锟斤拷筒锟斤拷芗锟铰硷拷锟叫╋拷锟戒。 锟斤拷使使锟斤拷log_statement = all锟斤拷锟矫ｏ拷锟斤拷锟斤拷锟斤拷锟斤法锟斤拷锟斤拷锟斤拷锟斤拷也锟斤拷锟结被锟斤拷录锟斤拷锟斤拷锟斤拷锟斤拷为只锟斤拷锟斤拷锟斤拷苫锟斤拷锟斤拷锓拷锟斤拷锟斤拷锟饺凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷之锟斤拷呕岱拷锟斤拷锟街撅拷锟较拷锟斤拷锟斤拷锟秸癸拷锟窖拷锟斤拷锟斤拷锟斤拷拢锟斤拷锟街达拷薪锥锟街帮拷锟斤拷锟斤拷诮锟斤拷锟斤拷锟斤拷锟斤拷锟芥划锟节间）锟斤拷锟斤拷锟斤拷锟斤拷锟揭诧拷锟斤拷岜伙拷锟铰硷拷锟斤拷锟�log_min_error_statement锟斤拷锟斤拷为ERROR锟斤拷锟斤拷锟斤拷停锟斤拷锟斤拷锟铰硷拷锟斤拷锟斤拷锟戒。
锟斤拷锟斤拷每锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟铰硷拷诜锟斤拷锟斤拷锟斤拷锟街撅拷小锟� 锟斤拷锟斤拷锟斤拷 51.3 锟斤拷锟斤拷取锟斤拷锟洁复锟斤拷锟斤拷锟斤拷锟斤拷锟较革拷锟较拷锟� 缺省值锟斤拷off锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟斤拷锟斤拷锟睫革拷锟斤拷锟斤拷锟斤拷谩锟�
锟斤拷锟狡硷拷录锟斤拷时锟侥硷拷锟斤拷锟酵尺寸。锟斤拷时锟侥硷拷锟斤拷锟皆憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟津、癸拷希锟酵存储锟斤拷时锟斤拷询锟斤拷锟斤拷锟斤拷锟矫恳伙拷锟斤拷锟绞憋拷募锟斤拷锟缴撅拷锟绞憋拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟街撅拷睢Ｒ伙拷锟斤拷锟街碉拷锟铰硷拷锟斤拷锟斤拷锟绞憋拷募锟斤拷锟较拷锟斤拷锟斤拷锟街抵伙拷锟铰硷拷叽锟斤拷锟节伙拷锟斤拷锟街革拷锟角э拷纸锟斤拷锟斤拷锟斤拷募锟斤拷锟侥拷锟斤拷锟斤拷锟轿� -1锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街硷拷录锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟斤拷锟皆革拷锟斤拷锟斤拷锟斤拷锟斤拷谩锟�
锟斤拷锟斤拷锟节凤拷锟斤拷锟斤拷锟斤拷志锟斤拷写锟斤拷锟绞憋拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷TimeZone锟斤拷同锟斤拷锟斤拷锟街碉拷羌锟斤拷胤锟轿э拷模锟斤拷锟斤拷锟斤拷锟叫会话锟斤拷锟斤拷锟斤拷一锟铰碉拷时锟斤拷锟斤拷锟斤拷诮锟侥拷锟街碉拷锟�GMT锟斤拷锟斤拷锟斤拷通锟斤拷锟结被锟斤拷postgresql.conf锟叫革拷锟角★拷initdb锟斤拷锟斤拷装一锟斤拷锟斤拷应锟斤拷锟斤拷系统锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷锟斤拷锟�锟斤拷 8.5.3 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷
锟斤拷锟斤拷锟斤拷log_destination锟叫碉拷csvlog锟斤拷锟结供锟斤拷一锟斤拷 锟斤拷莸姆锟绞斤拷锟斤拷锟斤拷菘锟斤拷械锟斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷选锟斤拷锟斤拷CSV锟斤拷式锟斤拷锟斤拷锟斤拷志锟叫ｏ拷 锟斤拷锟斤拷锟斤拷些锟叫ｏ拷 锟皆猴拷锟斤拷为锟斤拷位锟斤拷时锟斤拷锟斤拷锟斤拷没锟斤拷锟斤拷锟斤拷锟斤拷菘锟斤拷锟斤拷锟斤拷锟斤拷锟絀D锟斤拷锟酵伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟剿口号ｏ拷 锟结话ID锟斤拷每锟斤拷锟结话锟斤拷锟叫号ｏ拷锟斤拷锟斤拷锟角╋拷锟斤拷峄帮拷锟绞际憋拷洌拷锟斤拷锟斤拷锟斤拷锟絀D锟斤拷锟秸筹拷锟斤拷锟斤拷ID锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟皆ｏ拷SQLSTATE锟斤拷锟诫，锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷细锟斤拷息锟斤拷锟斤拷锟介， 锟斤拷锟铰达拷锟斤拷锟斤拷诓锟斤拷锟窖拷锟斤拷锟斤拷锟斤拷锟节ｏ拷锟斤拷锟斤拷锟叫的达拷锟斤拷位锟矫碉拷锟街凤拷统锟狡ｏ拷 锟斤拷锟斤拷围锟斤拷锟斤拷锟铰达拷锟斤拷锟斤拷没锟斤拷锟窖拷锟斤拷锟斤拷锟斤拷锟节ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷log_min_error_statement锟斤拷锟斤拷 锟斤拷锟叫的达拷锟斤拷位锟矫碉拷锟街凤拷统锟狡ｏ拷PostgreSQL源锟斤拷锟斤拷锟叫憋拷锟斤拷锟斤拷位锟矫ｏ拷锟斤拷锟� log_error_verbosity锟斤拷锟斤拷为verbose锟斤拷锟斤拷应锟矫筹拷锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟节存储CSV锟斤拷式锟斤拷志锟斤拷俚募虻ケ锟斤拷锟斤拷澹� 锟斤拷log_destination锟叫憋拷锟叫帮拷锟斤拷csvlog锟结供锟斤拷一锟街憋拷莘锟绞斤拷锟斤拷锟街撅拷募锟斤拷锟斤拷氲揭伙拷锟斤拷锟斤拷菘锟斤拷锟斤拷锟斤拷锟窖★拷罘拷锟斤拷锟斤拷欧指锟街碉拷锟�CSV锟斤拷锟斤拷式锟斤拷锟斤拷志锟叫ｏ拷锟斤拷锟斤拷锟斤拷些锟叫ｏ拷 锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷锟斤拷 锟矫伙拷锟斤拷锟斤拷 锟斤拷锟捷匡拷锟斤拷锟斤拷 锟斤拷锟斤拷 ID锟斤拷 锟酵伙拷锟斤拷锟斤拷锟斤拷:锟剿口号★拷 锟结话 ID锟斤拷 每锟斤拷锟结话锟斤拷锟叫号★拷 锟斤拷锟斤拷锟角╋拷锟� 锟结话锟斤拷始时锟戒、 锟斤拷锟斤拷锟斤拷锟斤拷 ID锟斤拷 锟斤拷通锟斤拷锟斤拷 ID锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟皆★拷 SQLSTATE 锟斤拷锟诫、 锟斤拷锟斤拷锟斤拷息锟斤拷 锟斤拷锟斤拷锟斤拷息锟斤拷锟介、 锟斤拷示锟斤拷 锟斤拷锟铰达拷锟斤拷锟斤拷诓锟斤拷锟窖拷锟斤拷锟斤拷锟叫ｏ拷锟斤拷 锟斤拷锟斤拷位锟斤拷锟斤拷锟节碉拷锟街凤拷锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟侥★拷 锟斤拷锟铰达拷锟斤拷锟斤拷没锟斤拷锟窖拷锟斤拷锟斤拷锟斤拷锟揭憋拷log_min_error_statement锟斤拷锟矫ｏ拷锟斤拷 锟斤拷锟斤拷位锟斤拷锟斤拷锟节碉拷锟街凤拷锟斤拷锟斤拷锟斤拷 锟斤拷 PostgreSQL 源锟斤拷锟斤拷锟叫达拷锟斤拷锟轿伙拷茫锟斤拷锟斤拷log_error_verbosity锟斤拷锟斤拷锟斤拷为verbose锟斤拷锟皆硷拷应锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟芥储 CSV 锟斤拷式锟斤拷志锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
CREATE TABLE postgres_log ( log_time timestamp(3) with time zone, user_name text, database_name text, process_id integer, connection_from text, session_id text, session_line_num bigint, command_tag text, session_start_time timestamp with time zone, virtual_transaction_id text, transaction_id bigint, error_severity text, sql_state_code text, message text, detail text, hint text, internal_query text, internal_query_pos integer, context text, query text, query_pos integer, location text, application_name text, PRIMARY KEY (session_id, session_line_num) );
使锟斤拷COPY FROM锟斤拷锟筋将一锟斤拷锟斤拷志锟侥硷拷锟斤拷锟诫到锟斤拷锟斤拷锟斤拷校锟�
COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
锟斤拷锟斤拷锟斤拷锟揭恍╋拷锟斤拷锟斤拷锟斤拷蚧锟斤拷锟� CSV 锟斤拷志锟侥硷拷锟斤拷
锟斤拷锟斤拷log_filename锟斤拷log_rotation_age为锟斤拷锟斤拷锟街撅拷募锟斤拷峁┮伙拷锟揭伙拷碌摹锟斤拷锟皆わ拷锟斤拷锟斤拷锟斤拷锟秸间。锟斤拷锟斤拷锟斤拷预锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟皆硷拷知锟斤拷什么时锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷志锟侥硷拷锟斤拷刹锟斤拷锟斤拷锟斤拷准锟斤拷锟矫憋拷锟斤拷锟诫。
锟斤拷log_rotation_size锟斤拷锟斤拷为 0 锟斤拷锟斤拷锟矫伙拷锟节尺达拷锟斤拷锟街撅拷锟阶拷锟斤拷锟轿拷锟绞癸拷锟斤拷锟街撅拷募锟斤拷锟斤拷锟斤拷锟皆わ拷狻�
锟斤拷log_truncate_on_rotation锟斤拷锟斤拷为on锟斤拷锟斤拷锟斤拷锟斤拷同一锟斤拷锟侥硷拷锟叫撅拷锟斤拷志锟斤拷锟捷诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷伙拷锟接★拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷诒锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿碉拷锟斤拷锟斤拷同锟斤拷锟斤拷息锟斤拷COPY锟斤拷锟斤拷一锟斤拷锟结交锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷荩锟斤拷锟斤拷锟轿何达拷锟襟将碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷失锟杰★拷锟斤拷锟斤拷愕硷拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟缴碉拷锟斤拷志锟侥硷拷锟斤拷锟斤拷锟皆猴拷锟斤拷锟斤拷全锟斤拷珊锟斤拷俅蔚锟斤拷耄拷锟斤拷锟轿ワ拷锟斤拷锟斤拷锟斤拷碌锟斤拷锟绞э拷堋锟斤拷锟饺碉拷锟斤拷志锟斤拷锟斤拷冶锟斤拷乇锟街拷锟斤拷俚锟斤拷搿ｏ拷锟斤拷锟斤拷锟斤拷也锟斤拷锟皆憋拷锟斤拷锟斤拷锟斤拷氐锟斤拷氩匡拷锟斤拷锟缴碉拷锟叫ｏ拷锟斤拷锟斤拷锟斤拷也锟斤拷锟斤拷锟斤拷COPY失锟杰★拷
锟斤拷些锟斤拷锟矫匡拷锟狡斤拷锟教憋拷锟斤拷锟斤拷ps锟斤拷锟斤拷伪锟斤拷薷牡摹锟� 锟斤拷锟斤拷锟斤拷 28.1 锟斤拷锟斤拷取锟斤拷锟介。
锟斤拷锟矫筹拷锟斤拷锟节硷拷群锟叫碉拷锟斤拷锟叫斤拷锟教憋拷锟斤拷锟叫的硷拷群锟斤拷锟狡★拷 锟斤拷锟狡匡拷锟斤拷锟斤拷锟轿猴拷小锟斤拷NAMEDATALEN锟街凤拷锟斤拷锟斤拷准64锟街凤拷锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷 只锟叫匡拷锟斤拷锟斤拷锟紸SCII锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷cluster_name值锟叫★拷 锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟绞猴拷锟芥换(?)锟斤拷 锟斤拷锟斤拷瞬锟斤拷锟斤拷锟斤拷锟轿拷锟斤拷址锟斤拷锟�''锟斤拷锟斤拷为缺省值锟斤拷锟斤拷锟斤拷锟斤拷示锟斤拷锟街★拷 锟剿诧拷锟斤拷只锟斤拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷锟矫★拷
锟斤拷锟矫革拷锟铰斤拷锟教憋拷锟斤拷锟斤拷锟斤拷裕锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷每锟轿凤拷锟斤拷锟斤拷锟斤拷锟秸碉拷一锟斤拷锟斤拷SQL锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷陆锟斤拷痰谋锟斤拷狻� 锟斤拷锟教憋拷锟斤拷通锟斤拷通锟斤拷ps锟斤拷锟斤拷锟斤拷锟介看锟斤拷 锟斤拷锟斤拷锟斤拷Windows锟斤拷锟斤拷锟斤拷锟教癸拷锟斤拷锟斤拷锟介看锟斤拷 只锟叫筹拷锟斤拷锟矫伙拷锟斤拷锟皆革拷锟斤拷锟斤拷锟斤拷锟斤拷谩锟�