Postgres Pro
Downloads
Home   >   mailing lists

Re: Wal files - Question | Postgres 9.2 - Mailing list pgsql-general

From Patrick B
Subject Re: Wal files - Question | Postgres 9.2
Date
Msg-id CAJNY3iv-RYkrkNgSgmKNai6Atg5M-B+eFH8toG8LjE3H5DEH1A@mail.gmail.com
Whole thread Raw
In response to Re: Wal files - Question | Postgres 9.2  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view


2016-12-01 14:15 GMT+13:00 David G. Johnston <david.g.johnston@gmail.com>:
On Wed, Nov 30, 2016 at 6:05 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
https://www.postgresql.org/docs/9.2/static/runtime-config-replication.html

wal_keep_segments is the parameter responsible for streaming replication be able to recover itself without using wal_files, is that right?

[...] ​without using wal_files[sic] [from an external archive location]

David J.
​



Yep David! Thanks for correcting me.

Got it now. Thanks everyone.

one more question...  I'm working with wal_keep_segments = 1000 - Would that in your opinion be a safe number?

Yes. I got plenty of free space and I'm using pg_xlogs in a different partition on the master.

Patrick

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Wal files - Question | Postgres 9.2
Next
From: John R Pierce
Date:
Subject: Re: Logging for 2 instances of PostgreSQL