Re: Reduce the size of the archived-log directory

The size of your directory will increase by 16mb on every checkpoint (16Mb
or 5 mins) so, even if your DB is completely idle you will get 16Mb per 5
mins, make the calculations and you'll see the space you need per day.

Vasilis Ventirozos

On Thu, Mar 28, 2013 at 8:54 AM, Hoàng Thanh Toàn - DB
<toanht(at)dtsc(dot)com(dot)vn>wrote:

> Hello Vasilis,****
>
> Thanks for your reply,****
>
> I thinks your archiving is successful for transfering WAL segments.****
>
> archive_command = 'test ! -f /mnt/FRA/ArchivedLog/%f && cp %p
> /mnt/FRA/ArchivedLog/%f' # command to use to archive a
> logfile segment****
>
> You are right that I am archiving at a local disk, but what it shall
> affect the size of the archived WAL directory.****
>
> ** **
>
> ############################## postgresql.conf (standalone
> server)###########################################****
>
> # - Settings -****
>
> ** **
>
> wal_level = archive # minimal, archive, or
> hot_standby****
>
> # (change
> requires restart)****
>
> #fsync = on # turns forced
> synchronization on or off****
>
> #synchronous_commit = on # synchronization level; on, off,
> or local****
>
> #wal_sync_method = fsync # the default is the first option**
> **
>
> # supported by
> the operating system:****
>
> #
> open_datasync****
>
> # fdatasync
> (default on Linux)****
>
> # fsync****
>
> #
> fsync_writethrough****
>
> # open_sync*
> ***
>
> #full_page_writes = on # recover from
> partial page writes****
>
> #wal_buffers = -1 # min 32kB, -1 sets based
> on shared_buffers****
>
> # (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 = 7 # 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 = 'test ! -f /mnt/FRA/ArchivedLog/%f && cp %p
> /mnt/FRA/ArchivedLog/%f' # command to use to archive a
> logfile segment****
>
> archive_timeout = 180 # force a logfile segment
> switch after this****
>
> # number of seconds; 0
> disables****
>
> # - Master Server -****
>
> ** **
>
> # These settings are ignored on a standby server****
>
> ** **
>
> #max_wal_senders = 0 # max number of walsender
> processes****
>
> # (change requires restart)
> ****
>
> #wal_sender_delay = 1s # walsender cycle time, 1-10000
> milliseconds****
>
> #wal_keep_segments = 0 # in logfile segments, 16MB each;
> 0 disables****
>
> #vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is
> delayed****
>
> #replication_timeout = 60s # in milliseconds; 0 disables****
>
> #synchronous_standby_names = '' # standby servers that provide sync rep
> ****
>
> # comma-separated list of
> application_name****
>
> # from standby(s); '*' =
> all****
>
> --****
>
> ** **
>
> *From:* Vasilis Ventirozos [mailto:v(dot)ventirozos(at)gmail(dot)com]
> *Sent:* Thursday, March 28, 2013 1:29 PM
> *To:* Hoàng Thanh Toàn - DB
> *Subject:* Re: [ADMIN] Reduce the size of the archived-log directory****
>
> ** **
>
> Hello,****
>
> its either your archiving is failing to transfer wal segments (check
> archiving_command) , or you are archiving at a local disk (you shouldnt,
> check archiving command) or you have an astronomical archive_keep_segments
> value****
>
> ** **
>
> ** **
>
> Vasilis Ventirozos****
>
> ** **
>
> ** **
>
> On Thu, Mar 28, 2013 at 8:10 AM, Hoàng Thanh Toàn - DB <toanht(at)dtsc(dot)com(dot)vn>
> wrote:****
>
> Dear all,****
>
> Please help me.****
>
> Please show me how to reduce the size of the archived-log directory.****
>
> My postgres database only get 4gbyte but the archived-log directory
> reaches several tens of gigabyte in one day.****
>
> please give me some advice.****
>
> Thanks a lot.****
>
> ****
>
> ****
>
> ** **
>
> ** **
>
>
>