postgresql 8.1.11 错误(sloved)

chinamyrice

Welcome to psql 8.1.11, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# \l
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!> \q

message中的提示：
       postmaster[3664]: segfault at 4 ip 081c5a94 sp bf8b3680 error 4 in postgres[8048000+2ad000]

不知道是什么问题

[ 本帖最后由 chinamyrice 于 2008-7-8 09:40 编辑 ]

大大狗

你的postgresql 服务已经停止了 重启一下 试试

chinamyrice

谢谢楼上
可是，我每执行一个命令都会出现如下错误：
root@debian00# tail -f  main.log
LOG:  server process (PID 5647) was terminated by signal 11
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
FATAL:  the database system is in recovery mode
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2008-06-20 14:26:51 CST
LOG:  checkpoint record is at 0/33A9DC
LOG:  redo record is at 0/33A9DC; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 565; next OID: 10794
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 0/33AA20
LOG:  redo is not required
LOG:  database system is ready
LOG:  transaction ID wrap limit is 2147484146, limited by database "postgres"

chinamyrice

已查明，是postgres用户没有postgresql.conf的读权限