Tom Lane <tgl@sss.pgh.pa.us> writes:
>>> Server don't recycles or removes WAL files at all, generating 12-20
>>> files every day.
>
> There's something broken there. Check to see why checkpoint operations
> are not completing (look in the postmaster log for relevant error
> messages). Open transactions should not affect this.
I get such periodical errors in my log when user connects to proftpd
server which uses posgresql for authentication:
003-07-31 00:21:10 [14889] LOG: query: select login from accounts where login = 'testuser'
2003-07-31 00:21:10 [14889] LOG: query: select homedir from accounts where login = 'testuser'
2003-07-31 00:21:10 [14889] LOG: query: select uid from accounts where login = 'testuser'
2003-07-31 00:21:10 [14889] LOG: query: select gid from accounts where login = 'testuser'
2003-07-31 00:21:10 [14889] LOG: query: select shell from accounts where login = 'testuser'
2003-07-31 00:21:12 [14889] LOG: query: select password from accounts where login = 'testuser' limit 1
2003-07-31 00:21:12 [14889] LOG: query: select login from accounts where 1
2003-07-31 00:21:12 [14889] ERROR: Argument of WHERE must be type boolean, not type integer
2003-07-31 00:21:12 [14889] LOG: statement: select login from accounts where 1
2003-07-31 00:21:12 [14889] LOG: query: select login from accounts where 1
2003-07-31 00:21:12 [14889] ERROR: Argument of WHERE must be type boolean, not type integer
2003-07-31 00:21:12 [14889] LOG: statement: select login from accounts where 1
2003-07-31 00:21:12 [14889] LOG: query: update accounts set login_count = login_count + 1 where login = 'testuser'
and when user disconnects:
2003-07-31 00:21:14 [14889] LOG: SSL SYSCALL error: EOF detected
2003-07-31 00:21:14 [14889] LOG: pq_recvbuf: unexpected EOF on client connection
No other errors messages in my log.
I have old version of proftpd installed in my system. I'm going to
install new version today. But I can delay this if needed (if it's
postgres bug) and look into proftpd sources.
--
Michael Govorun