Re: DB Cluster hanging - Mailing list pgsql-admin

From Tom Lane
Subject Re: DB Cluster hanging
Date
Msg-id 23602.1129223903@sss.pgh.pa.us
Whole thread Raw
In response to Re: DB Cluster hanging  ("Nigel Bishop" <Nigel.Bishop@ioko.com>)
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: "Nigel Bishop"
Date:
Subject: Re: DB Cluster hanging
Next
From: "Lane Van Ingen"
Date:
Subject: ADDLOCAL Parameter Values for Silent Istall