下载了postgresql-8.3.1-1安装。服务正常。系统进程如下
Process PID CPU Description Company Name
System Idle Process 0 78.46
Interrupts n/a Hardware Interrupts
DPCs n/a Deferred Procedure Calls
System 4
smss.exe 668 Windows NT Session Manager Microsoft Corporation
csrss.exe 716 Client Server Runtime Process Microsoft Corporation
winlogon.exe 740 Windows NT Logon Application Microsoft Corporation
services.exe 784 1.54 Services and Controller app Microsoft Corporation
svchost.exe 964 Generic Host Process for Win32 Services Microsoft Corporation
svchost.exe 1008 Generic Host Process for Win32 Services Microsoft Corporation
svchost.exe 1336 Generic Host Process for Win32 Services Microsoft Corporation
svchost.exe 1432 Generic Host Process for Win32 Services Microsoft Corporation
svchost.exe 1564 Generic Host Process for Win32 Services Microsoft Corporation
aswUpdSv.exe 1616 avast! Antivirus updating service ALWIL Software
ashServ.exe 1684 avast! antivirus service ALWIL Software
FlashFolder.exe 276 FlashFolder Service zett42
sqlservr.exe 372 SQL Server Windows NT Microsoft Corporation
ashMaiSv.exe 1140 avast! e-Mail Scanner Service ALWIL Software
ashWebSv.exe 1160 avast! Web Scanner ALWIL Software
alg.exe 444 Application Layer Gateway Service Microsoft Corporation
pg_ctl.exe 2840 pg_ctl - starts/stops/restarts the PostgreSQL server PostgreSQL Global Development Group
postgres.exe 532 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 420 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 3380 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 3072 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 3708 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 3912 PostgreSQL Server PostgreSQL Global Development Group
lsass.exe 796 LSA Shell (Export Version) Microsoft Corporation
procexp.exe 884 16.92 Sysinternals Process Explorer Sysinternals - www.sysinternals.com
blackbox.exe 1324 1.54 Blackbox for Windows
igfxtray.exe 160 igfxTray Module Intel Corporation
hkcmd.exe 1532 hkcmd Module Intel Corporation
jusched.exe 1308 Java(TM) Platform SE binary Sun Microsystems, Inc.
ashDisp.exe 1520 avast! service GUI component ALWIL Software
ctfmon.exe 416 CTF Loader Microsoft Corporation
sqlmangr.exe 440 SQL Server Service Manager Microsoft Corporation
isqlw.exe 944 ISQL/w - SQL graphical query tool Microsoft Corporation
vncviewer.exe 4036 vncviewer TightVNC Group
vncviewer.exe 4024 1.54 vncviewer TightVNC Group
cmd.exe 3776 Windows Command Processor Microsoft Corporation
psql.exe 272 psql - the PostgreSQL interactive terminal PostgreSQL Global Development Group
conime.exe 2484 Console IME Microsoft Corporation
apache.exe 2228 Apache HTTP Server Apache Software Foundation
apache.exe 2468 Apache HTTP Server Apache Software Foundation
mysqld.exe 224
PortableAppsMenu.exe 2780 PortableApps.com Menu PortableApps.com
FreeCommanderPortable.exe 2820 FreeCommander 2007 Portable Marek Jasinski & contributors
FreeCommander.exe 3304 Freeware file manager for windows Marek Jasinski - www.FreeCommander.com
firefox.exe 4068 Firefox Mozilla Corporation运行“psql至'postgres'”,提交第二个命令后就:
服务器意外地关闭了联接
这种现象通常意味着服务器在处理请求之前
或者正在处理请求的时候意外中止
与伺服器的连线已遗失,尝试重置: 失败。
此时查看所有的postgres进程均结束了。why?
Process PID CPU Description Company Name
System Idle Process 0 78.46
Interrupts n/a Hardware Interrupts
DPCs n/a Deferred Procedure Calls
System 4
smss.exe 668 Windows NT Session Manager Microsoft Corporation
csrss.exe 716 Client Server Runtime Process Microsoft Corporation
winlogon.exe 740 Windows NT Logon Application Microsoft Corporation
services.exe 784 1.54 Services and Controller app Microsoft Corporation
svchost.exe 964 Generic Host Process for Win32 Services Microsoft Corporation
svchost.exe 1008 Generic Host Process for Win32 Services Microsoft Corporation
svchost.exe 1336 Generic Host Process for Win32 Services Microsoft Corporation
svchost.exe 1432 Generic Host Process for Win32 Services Microsoft Corporation
svchost.exe 1564 Generic Host Process for Win32 Services Microsoft Corporation
aswUpdSv.exe 1616 avast! Antivirus updating service ALWIL Software
ashServ.exe 1684 avast! antivirus service ALWIL Software
FlashFolder.exe 276 FlashFolder Service zett42
sqlservr.exe 372 SQL Server Windows NT Microsoft Corporation
ashMaiSv.exe 1140 avast! e-Mail Scanner Service ALWIL Software
ashWebSv.exe 1160 avast! Web Scanner ALWIL Software
alg.exe 444 Application Layer Gateway Service Microsoft Corporation
pg_ctl.exe 2840 pg_ctl - starts/stops/restarts the PostgreSQL server PostgreSQL Global Development Group
postgres.exe 532 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 420 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 3380 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 3072 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 3708 PostgreSQL Server PostgreSQL Global Development Group
postgres.exe 3912 PostgreSQL Server PostgreSQL Global Development Group
lsass.exe 796 LSA Shell (Export Version) Microsoft Corporation
procexp.exe 884 16.92 Sysinternals Process Explorer Sysinternals - www.sysinternals.com
blackbox.exe 1324 1.54 Blackbox for Windows
igfxtray.exe 160 igfxTray Module Intel Corporation
hkcmd.exe 1532 hkcmd Module Intel Corporation
jusched.exe 1308 Java(TM) Platform SE binary Sun Microsystems, Inc.
ashDisp.exe 1520 avast! service GUI component ALWIL Software
ctfmon.exe 416 CTF Loader Microsoft Corporation
sqlmangr.exe 440 SQL Server Service Manager Microsoft Corporation
isqlw.exe 944 ISQL/w - SQL graphical query tool Microsoft Corporation
vncviewer.exe 4036 vncviewer TightVNC Group
vncviewer.exe 4024 1.54 vncviewer TightVNC Group
cmd.exe 3776 Windows Command Processor Microsoft Corporation
psql.exe 272 psql - the PostgreSQL interactive terminal PostgreSQL Global Development Group
conime.exe 2484 Console IME Microsoft Corporation
apache.exe 2228 Apache HTTP Server Apache Software Foundation
apache.exe 2468 Apache HTTP Server Apache Software Foundation
mysqld.exe 224
PortableAppsMenu.exe 2780 PortableApps.com Menu PortableApps.com
FreeCommanderPortable.exe 2820 FreeCommander 2007 Portable Marek Jasinski & contributors
FreeCommander.exe 3304 Freeware file manager for windows Marek Jasinski - www.FreeCommander.com
firefox.exe 4068 Firefox Mozilla Corporation运行“psql至'postgres'”,提交第二个命令后就:
服务器意外地关闭了联接
这种现象通常意味着服务器在处理请求之前
或者正在处理请求的时候意外中止
与伺服器的连线已遗失,尝试重置: 失败。
此时查看所有的postgres进程均结束了。why?
请看具体的log
2008-04-29 10:40:53 GMT 提示: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
2008-04-29 10:40:53 GMT 比致命错误还过分的错误: ERRORDATA_STACK_SIZE exceeded
2008-04-29 10:40:53 GMT 比致命错误还过分的错误: 无效的 "UTF8" 编码字节顺序: 0xb1
以前用8.2没问题。