Re: BUG #5082: I can't get logfile( achive )

On Fri, Sep 25, 2009 at 11:50 AM, smuffy <vday1945(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5082
> Logged by:          smuffy
> Email address:      vday1945(at)gmail(dot)com
> PostgreSQL version: 8.4.0
> Operating system:   opensuse 10.2
> Description:        I can't get logfile( achive )
> Details:
>
> hello.
>
> My DB can't make a logfile( archive ).
> But archive_mode is on.(postgresql.conf)
> How I get a logfile?
> help me, please.

This isn't a bug; it's a usage question that should be posted to
pgsql-general or pgsql-novice.

Probably the first thing you want to do is look through your server
logs and see if there are any informative error messages in there, or
any indication of archiving activity.

One possibility is that you aren't generating very much WAL activity,
so it's taking a very long time between archive files. You could try
issuing an explicit CHECKPOINT or setting archive_timeout.

...Robert