Search Postgresql Archives

Re: Unable to recovery due missing wal_file

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

 





Not sure that would have mattered for the reasons below.

You might want to take a look at the below:

https://www.postgresql.org/docs/9.5/static/wal.html

In particular:

https://www.postgresql.org/docs/9.5/static/wal-intro.html

Short version WAL files are essential to restoring and on the originating server are recycled, subject to the configuration parameters explained here:

https://www.postgresql.org/docs/9.5/static/wal-configuration.html

So the wal archiving you have set up is not storing everything, it removes older files over time?

Yes... it removes... I've changed to store them for up to 72h.

I'll restart the process now, by using stream instead fletch.

Let's see.... =\ 


[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