Re: DB Cluster hanging

"Nigel Bishop" <Nigel.Bishop@ioko.com> writes:
> Hmm...  a possible bug eh!  I'll make sure that the log destination
> doesn't fill again

> This is what I have in the postgresql.conf file:

> log_destination = 'stderr'
> redirect_stderr = true

I tried to reproduce the problem, without any success.  What I did:
* set up a small loopback filesystem, so I didn't have to actually fill
  my whole disk;
* point Postgres logging into the loopback filesystem;
* deliberately fill the filesystem.

I didn't see any lockup.  The syslogger subprocess started bleating on
the original postmaster stderr:
    could not write to log file: No space left on device
    could not write to log file: No space left on device
but it dropped the messages rather than hanging up, and the rest
of the database sailed on just fine.  When I freed up space on the
loopback filesystem, logging resumed without any problem.

So I dunno what went wrong for you.  System-specific issue maybe?
I tried this on Fedora Core 4 with CVS-tip Postgres (but the syslogger
code hasn't changed materially since 8.0.2).

Also, are you sure the postmaster is 8.0.3?  There was an
infinite-recursion-on-error bug in syslogger in 8.0 and 8.0.1.

            regards, tom lane