From toanht@dtsc.com.vn Thu Mar 28 06:08:49 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL613-0007Hu-SC for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2013 06:08:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UL612-0007Hk-UW for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2013 06:08:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL611-0007He-Ra for pgsql-admin@postgresql.org; Thu, 28 Mar 2013 06:08:47 +0000 Received: from zimbra1.eab.com.vn ([203.77.178.15]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL60y-0000EH-3p for pgsql-admin@postgresql.org; Thu, 28 Mar 2013 06:08:47 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbra1.eab.com.vn (Postfix) with ESMTP id 515952A52CC for ; Thu, 28 Mar 2013 13:08:42 +0700 (ICT) X-Virus-Scanned: amavisd-new at zimbra1.eab.com.vn Received: from zimbra1.eab.com.vn ([127.0.0.1]) by localhost (zimbra1.eab.com.vn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HO2pSSLIkJ4A for ; Thu, 28 Mar 2013 13:08:41 +0700 (ICT) Received: by zimbra1.eab.com.vn (Postfix, from userid 102) id B63352A52A8; Thu, 28 Mar 2013 13:08:41 +0700 (ICT) Received: from THANHTOAN (unknown [192.168.69.69]) by zimbra1.eab.com.vn (Postfix) with ESMTPSA id 8550A2A52A8 for ; Thu, 28 Mar 2013 13:08:41 +0700 (ICT) From: =?iso-8859-1?Q?Ho=E0ng_Thanh_To=E0n_-_DB?= To: Subject: Reduce the size of the archived-log directory Date: Thu, 28 Mar 2013 13:08:45 +0700 Message-ID: <000001ce2b7a$b45e3380$1d1a9a80$@com.vn> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01CE2BB5.60BD0B80" X-Mailer: Microsoft Office Outlook 12.0 Content-Language: en-us Thread-Index: Ac4rerQp2RMduLJDSfib76dBie/0Rw== X-Copyrighted-Material: X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_0001_01CE2BB5.60BD0B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. =20 =20 -- Best Regards, Ho=E0ng Thanh To=E0n, Dong Tien Service Corporation 4th Floor, 418 Tran Phu Street, Ward 7, District 5, Ho Chi Minh City Mobile: 0908915195 Yahoo: hoangthanhtoan1704 =20 ------=_NextPart_000_0001_01CE2BB5.60BD0B80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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.

 

 

--<= /span>

Best Regards,
Ho=E0ng Thanh To=E0n,
Dong Tien Service Corporation
4th Floor, 418 Tran Phu Street, Ward 7, District 5, Ho Chi Minh City
Mobile: 0908915195

Yahoo: hoangthanhtoan1704

 


=
= ------=_NextPart_000_0001_01CE2BB5.60BD0B80-- From toanht@dtsc.com.vn Thu Mar 28 06:10:39 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL62p-0007Rq-7w for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2013 06:10:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UL62o-0000LA-Ly for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2013 06:10:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL62l-0000IK-V4 for pgsql-admin@postgresql.org; Thu, 28 Mar 2013 06:10:36 +0000 Received: from zimbra1.eab.com.vn ([203.77.178.15]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL62i-0000IW-4I for pgsql-admin@postgresql.org; Thu, 28 Mar 2013 06:10:35 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbra1.eab.com.vn (Postfix) with ESMTP id 80E902A52CC for ; Thu, 28 Mar 2013 13:10:30 +0700 (ICT) X-Virus-Scanned: amavisd-new at zimbra1.eab.com.vn Received: from zimbra1.eab.com.vn ([127.0.0.1]) by localhost (zimbra1.eab.com.vn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id XZwKq0dj-5xz for ; Thu, 28 Mar 2013 13:10:29 +0700 (ICT) Received: by zimbra1.eab.com.vn (Postfix, from userid 102) id EC3DF2A52A8; Thu, 28 Mar 2013 13:10:29 +0700 (ICT) Received: from THANHTOAN (unknown [192.168.69.69]) by zimbra1.eab.com.vn (Postfix) with ESMTPSA id CE02C2A52A8 for ; Thu, 28 Mar 2013 13:10:29 +0700 (ICT) From: =?iso-8859-1?Q?Ho=E0ng_Thanh_To=E0n_-_DB?= To: Subject: Reduce the size of the archived-log directory Date: Thu, 28 Mar 2013 13:10:33 +0700 Message-ID: <000501ce2b7a$f4eb5130$dec1f390$@com.vn> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0006_01CE2BB5.A14A2930" X-Mailer: Microsoft Office Outlook 12.0 Content-Language: en-us Thread-Index: Ac4revTFasyHkDe9RjuPVj5ZkrTpEg== X-Copyrighted-Material: X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_0006_01CE2BB5.A14A2930 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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. ------=_NextPart_000_0006_01CE2BB5.A14A2930 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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.

 

 


=
= ------=_NextPart_000_0006_01CE2BB5.A14A2930-- From v.ventirozos@gmail.com Thu Mar 28 07:12:34 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL70j-0003gF-IF for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2013 07:12:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UL70i-0008A3-Fz for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2013 07:12:32 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL70f-00089v-Vl for pgsql-admin@postgresql.org; Thu, 28 Mar 2013 07:12:30 +0000 Received: from mail-we0-x22f.google.com ([2a00:1450:400c:c03::22f]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UL70b-0003xc-Rc for pgsql-admin@postgresql.org; Thu, 28 Mar 2013 07:12:28 +0000 Received: by mail-we0-f175.google.com with SMTP id t11so5854660wey.34 for ; Thu, 28 Mar 2013 00:12:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=9ofNZWCiYIFx2RQLHc7T+OkcaNfsoF/3RP+SKwVLXIw=; b=dkk3gdsScbfIUHhz8BuxgC72o2D0zzN/c4a49AAfQ2x+g2YAJqDolF0FqVhxmgSnNS U4MUoRb4BzhQgEUcuyZpaF4Hff+ogl7eyIil7Z4h7boLjLaX9ghqtivEP+PST7fjN7Sr Zw/05OwnjeR1PPKBAnri9/CEB1jFR2avUY3dcPGyfGXfZg+ThBykXGdwewyGy5mqN5mF rhxGk+ICYEI6i/EkButDlkSizR/bsXxCow0+8/sakRMdpM6mK7uN3YUXTBaZli2AVycm gVRvvVObYcf3YDCMdh+QYiFMfzWR6dn0zk//P0SjZin19HG/36ro2zZck96VmiRehDhq s00w== MIME-Version: 1.0 X-Received: by 10.194.92.231 with SMTP id cp7mr35993211wjb.19.1364454743625; Thu, 28 Mar 2013 00:12:23 -0700 (PDT) Received: by 10.216.84.137 with HTTP; Thu, 28 Mar 2013 00:12:23 -0700 (PDT) In-Reply-To: <001901ce2b81$187ffe60$497ffb20$@com.vn> References: <000501ce2b7a$f4eb5130$dec1f390$@com.vn> <001901ce2b81$187ffe60$497ffb20$@com.vn> Date: Thu, 28 Mar 2013 09:12:23 +0200 Message-ID: Subject: Re: Reduce the size of the archived-log directory From: Vasilis Ventirozos To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=047d7bfd0c2e4e567504d8f6e004 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --047d7bfd0c2e4e567504d8f6e004 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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=E0ng Thanh To=E0n - DB wrote: > Hello Vasilis,**** > > Thanks for your reply,**** > > I thinks your archiving is successful for transfering WAL segments.**** > > archive_command =3D '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 =3D archive # minimal, archive, or > hot_standby**** > > # (change > requires restart)**** > > #fsync =3D on # turns forced > synchronization on or off**** > > #synchronous_commit =3D on # synchronization level; on, off= , > or local**** > > #wal_sync_method =3D fsync # the default is the first optio= n** > ** > > # supported b= y > the operating system:**** > > # > open_datasync**** > > # fdatasync > (default on Linux)**** > > # fsync**** > > # > fsync_writethrough**** > > # open_sync= * > *** > > #full_page_writes =3D on # recover fro= m > partial page writes**** > > #wal_buffers =3D -1 # min 32kB, -1 sets ba= sed > on shared_buffers**** > > # (change > requires restart)**** > > #wal_writer_delay =3D 200ms # 1-10000 milliseconds**** > > ** ** > > #commit_delay =3D 0 # range 0-100000, in > microseconds**** > > #commit_siblings =3D 5 # range 1-1000**** > > # - Checkpoints -**** > > ** ** > > checkpoint_segments =3D 7 # in logfile segments, min 1, > 16MB each**** > > #checkpoint_timeout =3D 5min # range 30s-1h**** > > #checkpoint_completion_target =3D 0.5 # checkpoint target > duration, 0.0 - 1.0**** > > #checkpoint_warning =3D 30s # 0 disables**** > > ** ** > > # - Archiving -**** > > ** ** > > archive_mode =3D on # allows archiving to be done**** > > # (change requires restar= t) > **** > > archive_command =3D 'test ! -f /mnt/FRA/ArchivedLog/%f && cp %p > /mnt/FRA/ArchivedLog/%f' # command to use to archive a > logfile segment**** > > archive_timeout =3D 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 =3D 0 # max number of walsender > processes**** > > # (change requires restar= t) > **** > > #wal_sender_delay =3D 1s # walsender cycle time, 1-10= 000 > milliseconds**** > > #wal_keep_segments =3D 0 # in logfile segments, 16MB ea= ch; > 0 disables**** > > #vacuum_defer_cleanup_age =3D 0 # number of xacts by which cleanup is > delayed**** > > #replication_timeout =3D 60s # in milliseconds; 0 disables**** > > #synchronous_standby_names =3D '' # standby servers that provide sync = rep > **** > > # comma-separated list of > application_name**** > > # from standby(s); '*' = =3D > all**** > > --**** > > ** ** > > *From:* Vasilis Ventirozos [mailto:v.ventirozos@gmail.com] > *Sent:* Thursday, March 28, 2013 1:29 PM > *To:* Ho=E0ng Thanh To=E0n - 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_segment= s > value**** > > ** ** > > ** ** > > Vasilis Ventirozos**** > > ** ** > > ** ** > > On Thu, Mar 28, 2013 at 8:10 AM, Ho=E0ng Thanh To=E0n - DB > 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.**** > > **** > > **** > > ** ** > > ** ** > > > --047d7bfd0c2e4e567504d8f6e004 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 m= ins, make the calculations and you'll see the space you need per day.

Vasilis Ventirozos
=A0

On Thu,= Mar 28, 2013 at 8:54 AM, Ho=E0ng Thanh To=E0n - DB <<= a href=3D"mailto:toanht@dtsc.com.vn" target=3D"_blank">toanht@dtsc.com.vn> wrote:

Hello Vasilis,

Thanks for your reply,

I thinks your archiving is = successful for transfering WAL segments.

archive_command =3D 'te= st ! -f /mnt/FRA/ArchivedLog/%f && cp %p /mnt/FRA/ArchivedLog/%f'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # command to use to archive a logfile segment

You are right that I am arc= hiving at a local disk, but what it shall affect the size of the archived WAL directory.

=A0

###########################= ### postgresql.conf (standalone server)###########################################

# - Settings -

=A0

wal_level =3D archive=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # minimal, archive, or hot_standby

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # (change requires restart)

#fsync =3D on=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # turns forced synchronization on or off

#synchronous_commit =3D on= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # synchronization level; on, off, or local

#wal_sync_method =3D fsync= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # the default is the first option

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # supported by the operating system:

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= #=A0=A0 open_datasync

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= #=A0=A0 fdatasync (default on Linux)

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= #=A0=A0 fsync

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= #=A0=A0 fsync_writethrough

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= #=A0=A0 open_sync

#full_page_writes =3D on=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 # recover from partial page writes

#wal_buffers =3D -1=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 # min 32kB, -1 sets based on shared_buffers

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # (change requires restart)

#wal_writer_delay =3D 200ms= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 1-10000 milliseconds=

=A0

#commit_delay =3D 0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # range 0-100000, in microseconds

#commit_siblings =3D 5=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = range 1-1000

# - Checkpoints -=

=A0

checkpoint_segments =3D 7= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # in logfile segments, min 1, 16MB each

#checkpoint_timeout =3D 5mi= n=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # range 30s-1h

#checkpoint_completion_targ= et =3D 0.5=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # checkpoint target duration, 0.0 - 1.0

#checkpoint_warning =3D 30s= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 disables

=A0

# - Archiving -

=A0

archive_mode =3D on=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # allows archiving to be done

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

archive_command =3D 'test != -f /mnt/FRA/ArchivedLog/%f && cp %p /mnt/FRA/ArchivedLog/%f'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # command to use to archive a logfile segment

archive_timeout =3D 180=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # force a l= ogfile segment switch after this

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # number of seconds; 0 disables

# - Master Server -<= u>

=A0

# These settings are ignore= d on a standby server

=A0

#max_wal_senders =3D 0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # max number o= f walsender processes

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

#wal_sender_delay =3D 1s=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # walsender cycle time, 1-10000 milliseconds

#wal_keep_segments =3D 0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # in logfile segments, 16MB each; 0 disables

#vacuum_defer_cleanup_age = =3D 0=A0=A0=A0=A0 # number of xacts by which cleanup is delayed

#replication_timeout =3D 60= s=A0=A0=A0=A0=A0 # in milliseconds; 0 disables

#synchronous_standby_names = =3D ''=A0=A0=A0 # standby servers that provide sync rep

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # comma-separated list of application_name

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # from standby(s); '*' =3D all

--

=A0

From: Vasilis = Ventirozos [mailto:v.venti= rozos@gmail.com]
Sent: Thursday, March 28, 2013 1:29 PM
To: Ho=E0ng Thanh To=E0n - DB
Subject: Re: [ADMIN] Reduce the size of the archived-log directory

=A0

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

=A0

=A0

Vasilis Ventirozos

=A0

=A0

On Thu, Mar 28, 2013 at 8:10 AM, Ho=E0ng Thanh To=E0= n - DB <toanht@d= tsc.com.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.

=A0

=A0

=A0

=A0




--047d7bfd0c2e4e567504d8f6e004--