Search Postgresql Archives

Re: WAL archive on slave

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






On Mon, Feb 10, 2014 at 9:43 AM, James Sewell <james.sewell@xxxxxxxxxxxx> wrote:
Hi again,

I just realised I asked this question around a year ago (for a different reason actually) and you answered me then! Amazing!

Your answer then was:

It works fine, only the server will not generate WAL while 
it is in recovery.  As soon as you promote the standby, 
it will archive ist WALs. 

Is this still correct?
Yes, it is. A slave will begin to archive WALs after getting promoted and dumping to a new timeline.
 
I'm still not sure why they wouldn't be archived on the slave, seen as they show up in the directory?
WAL files are only replayed on a slave, not archived.
Regards
--
Michael

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux