pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWal archives building up in slave pg_xlog dir
3+ messages / 2 participants
[nested] [flat]
* Wal archives building up in slave pg_xlog dir
@ 2011-03-23 21:16 Simon Luijk <simonluijk@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Simon Luijk @ 2011-03-23 21:16 UTC (permalink / raw)
To: pgsql-admin
I have a master slave setup that is on the most part working smoothly. The logs are getting
shipped to the slave, the slave is requesting them and then applying them.
The problem is that the logs are building up in the pg_xlog dir and not overwriting. I do have
archive_mode on in postgresql.conf so when the slave needs to come online as the new
primary it start shipping its logs. Is this setting effecting recovery mode too?
Thanks in advance
Simon
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Wal archives building up in slave pg_xlog dir
@ 2011-03-26 11:39 Simon Luijk <simonluijk@gmail.com>
parent: Simon Luijk <simonluijk@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Simon Luijk @ 2011-03-26 11:39 UTC (permalink / raw)
To: pgsql-admin
So I have turned archive_mode off on the slave. At first I thought this solved it but
the logs are still building up. Could anyone shed some light on why the logs are building
up in pg_xlog?
Thank you
Simon
On Wednesday, 23 March 2011 at 22:16, Simon Luijk wrote:
> I have a master slave setup that is on the most part working smoothly. The logs are getting
> shipped to the slave, the slave is requesting them and then applying them.
>
> The problem is that the logs are building up in the pg_xlog dir and not overwriting. I do have
> archive_mode on in postgresql.conf so when the slave needs to come online as the new
> primary it start shipping its logs. Is this setting effecting recovery mode too?
>
> Thanks in advance
> Simon
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Wal archives building up in slave pg_xlog dir
@ 2011-03-28 21:48 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Simon Luijk <simonluijk@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2011-03-28 21:48 UTC (permalink / raw)
To: Simon Luijk <simonluijk@gmail.com>; pgsql-admin
[rearranged; please don't top-post]
Simon Luijk <simonluijk@gmail.com> wrote:
> On Wednesday, 23 March 2011 at 22:16, Simon Luijk wrote:
>> I have a master slave setup that is on the most part working
>> smoothly. The logs are getting shipped to the slave, the slave is
>> requesting them and then applying them.
>>
>> The problem is that the logs are building up in the pg_xlog dir
>> and not overwriting. I do have archive_mode on in postgresql.conf
>> so when the slave needs to come online as the new primary it
>> start shipping its logs. Is this setting effecting recovery mode
>> too?
> I have turned archive_mode off on the slave. At first I thought
> this solved it but the logs are still building up. Could anyone
> shed some light on why the logs are building up in pg_xlog?
Are they building up in the location your master's archive script
puts them, or in the slave's pg_xlog directory. (Those should not
be the same place.)
If you run pg_controldata against the slave's data directory, does
it show progress in recovery?
-Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-03-28 21:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-03-23 21:16 Wal archives building up in slave pg_xlog dir Simon Luijk <simonluijk@gmail.com>
2011-03-26 11:39 ` Simon Luijk <simonluijk@gmail.com>
2011-03-28 21:48 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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