pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 9.2 pg_xlog cleanup
3+ messages / 3 participants
[nested] [flat]
* Postgres 9.2 pg_xlog cleanup
@ 2013-11-27 15:57 Marcello Lorenzi <mlorenzi@sorint.it>
0 siblings, 2 replies; 3+ messages in thread
From: Marcello Lorenzi @ 2013-11-27 15:57 UTC (permalink / raw)
To: pgsql-admin
Hi All,
I'm installing a new Postgres 9.2 instance on my test environment and I
noticed that the pg_xlog directory use a lot of space. I already
configured the WAL but not the archiving for this datsa. Is it possible
to implement a retention on pg_xlog data files?
Thanks,
Marcello
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres 9.2 pg_xlog cleanup
@ 2013-11-27 16:25 Raghu Ram <raghuchennuru@gmail.com>
parent: Marcello Lorenzi <mlorenzi@sorint.it>
1 sibling, 0 replies; 3+ messages in thread
From: Raghu Ram @ 2013-11-27 16:25 UTC (permalink / raw)
To: Marcello Lorenzi <mlorenzi@sorint.it>; +Cc: pgsql-admin
On Wed, Nov 27, 2013 at 9:27 PM, Marcello Lorenzi <mlorenzi@sorint.it>wrote:
> Hi All,
> I'm installing a new Postgres 9.2 instance on my test environment and I
> noticed that the pg_xlog directory use a lot of space. I already configured
> the WAL but not the archiving for this datsa. Is it possible to implement a
> retention on pg_xlog data files?
>
>
WAL buffers holds the changes made to the database in the transaction
logs(pg_xlogs), in order to guarantee transaction security. When a
transaction commits,all transaction records are stored in to disk/permanent
storage i.e Pg_xlog directory.
I would request to monitor database server log file located under "pg_log"
directory,may be archive command failing due to that .ready files are
increasing under ../pg_xlog/archive_status directory and occupying more
space. If you fix the archive command issues,then everything will comes
under control.
Thanks & Regards
Raghu Ram
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres 9.2 pg_xlog cleanup
@ 2013-11-27 21:05 Ray Stell <stellr@vt.edu>
parent: Marcello Lorenzi <mlorenzi@sorint.it>
1 sibling, 0 replies; 3+ messages in thread
From: Ray Stell @ 2013-11-27 21:05 UTC (permalink / raw)
To: Marcello Lorenzi <mlorenzi@sorint.it>; +Cc: pgsql-admin
On Nov 27, 2013, at 10:57 AM, Marcello Lorenzi <mlorenzi@sorint.it> wrote:
> Is it possible to implement a retention on pg_xlog data files?
"wal_keep_segments (integer) Specifies the minimum number of past log file segments kept in the pg_xlog directory"
http://www.postgresql.org/docs/9.2/static/runtime-config-replication.html
Attachments:
signature.asc (application/pgp-signature, 235B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-11-27 21:05 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-11-27 15:57 Postgres 9.2 pg_xlog cleanup Marcello Lorenzi <mlorenzi@sorint.it>
2013-11-27 16:25 ` Raghu Ram <raghuchennuru@gmail.com>
2013-11-27 21:05 ` Ray Stell <stellr@vt.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox