Re: Don't removes/recycles WAL files at all

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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