Skip site navigation (1) Skip section navigation (2)

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

From: "smuffy" <vday1945(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5082: I can't get logfile( achive )
Date: 2009-09-25 15:50:37
Message-ID: 200909251550.n8PFobmg060363@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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.


#---------------------------------------------------------------------------
---
# 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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-09-25 18:01:34
Subject: Re: Postgresql 8.4.1 segfault, backtrace
Previous:From: Tom LaneDate: 2009-09-25 14:29:24
Subject: Re: diferent timezones in the same table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group