postgresql - pgagent centos 6.2

Question

我成功了compiled pgagent from source on a CentOS 6.2 server .

当我尝试使用以下命令启动 pgagent 时:

/usr/bin/pgagent -l 2 hostaddr=serveur.com dbname=postgres user=postgres

我收到以下错误消息:

DEBUG:      user         : postgres
DEBUG:      port         : 0
DEBUG:      host         : server.com
DEBUG:      dbname       : postgres
DEBUG:      password     : 
DEBUG:      conn timeout : 0
DEBUG: Connection Information:
DEBUG:      user         : postgres
DEBUG:      port         : 0
DEBUG:      host         : server.com
DEBUG:      dbname       : postgres
DEBUG:      password     : 
DEBUG:      conn timeout : 0
DEBUG: Creating DB connection: user=postgres host=server.com dbname=postgres
DEBUG: Database sanity check
DEBUG: Clearing zombies
WARNING: Query error: ERROR:  could not extend file "base/12870/12615": No space left on device
HINT:  Check free disk space.

WARNING: Query error: ERROR:  relation "pga_tmp_zombies" does not exist
LINE 1: INSERT INTO pga_tmp_zombies (jagpid) SELECT jagpid   FROM pg...
                    ^

WARNING: Query error: ERROR:  table "pga_tmp_zombies" does not exist

WARNING: Query error: ERROR:  could not extend file "base/12870/17167": No space left on device
HINT:  Check free disk space.

WARNING: Couldn't create the primary connection (attempt 1): ERROR:  could not extend file "base/12870/17167": No space left on device
HINT:  Check free disk space.
DEBUG: Clearing all connections
DEBUG: Connection stats: total - 1, free - 0, deleted - 1

知道问题的根源吗？

Answer 1

WARNING: Query error: ERROR:  could not extend file "base/12870/12615": No space left on device
HINT:  Check free disk space.

您的磁盘空间不足，或者(不太可能)数据库用户已达到磁盘访问配额限制。对于某些平台和文件系统，您也可能在文件系统上用完了 inode。查看 df .