Обсуждение: BUG #5082: I can't get logfile( achive )

The following bug has been logged online:

Bug reference:      5082
Logged by:          smuffy
Email address:      vday1945@gmail.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.


#---------------------------------------------------------------------------
---
# WRITE AHEAD LOG
#---------------------------------------------------------------------------
---

# - Settings -

#fsync = on                             # turns forced synchronization on or
off
#synchronous_commit = on                # immediate fsync at commit
#wal_sync_method = fsync                # the default is the first option
                                        # supported by the operating
system:
                                        #   open_datasync
                                        #   fdatasync
                                        #   fsync
                                        #   fsync_writethrough
                                        #   open_sync
#full_page_writes = on                  # recover from partial page writes
#wal_buffers = 64kB                     # min 32kB
                                        # (change requires restart)
#wal_writer_delay = 200ms               # 1-10000 milliseconds

#commit_delay = 0                       # range 0-100000, in microseconds
#commit_siblings = 5                    # range 1-1000

# - Checkpoints -

#checkpoint_segments = 3                # in logfile segments, min 1, 16MB
each
#checkpoint_timeout = 5min              # range 30s-1h
#checkpoint_completion_target = 0.5     # checkpoint target duration, 0.0 -
1.0
#checkpoint_warning = 30s               # 0 disables

# - Archiving -

archive_mode = on               # allows archiving to be done
                                # (change requires restart)
#archive_command = ''           # command to use to archive a logfile
segment
archive_command = '/bin/cp -i %p /data/postgres/log/archive/%f'
#archive_timeout = 0            # force a logfile segment switch after this
                                # number of seconds; 0 disables

On Fri, Sep 25, 2009 at 11:50 AM, smuffy <vday1945@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05082
> Logged by: =A0 =A0 =A0 =A0 =A0smuffy
> Email address: =A0 =A0 =A0vday1945@gmail.com
> PostgreSQL version: 8.4.0
> Operating system: =A0 opensuse 10.2
> Description: =A0 =A0 =A0 =A0I 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